I have a Power BI page with scroll means page size is Height 1500px and width 1280px.
I have three slicer on top page Country, State and City
Client requirement is, when scrolling down in the page, slicer is not visible. Please make the Slicer sticky so when scrolling down we can change the slicer and slicer should be visible.
Please find the attached sample PBIX file.
I tried to use CSS and Javascript code in measure " " but the measure is not working.
Power BI’s native design does not support “sticky” slicers as you’ve described. When the entire window requires scrolling, as is the case with your report, all elements on the page will move with the scroll.
A straightforward solution is to revisit the report’s design and layout. By rearranging or resizing visuals, you can optimize the available space, potentially reducing or even eliminating the need for scrolling. This might require adjusting the size of charts, tables, or other visuals to fit the window’s confines, which means making trade-offs in visualization size or data displayed.
Another approach is to divide the report into multiple pages. By categorizing visuals based on themes or topics, you can ensure all content is visible without scrolling.
Lastly, consider creating a dashboard instead of a single report page. Dashboards let you pin visuals from various report pages, including slicers, offering a more suitable layout for restricted window sizes.
I have created one sample pbix file but in production version report, we have many visual and all visual are arranged properly arranged. So I cant break in different page. This is also client requirement.
Are there any hack to achieve the requirement like using HTML Container or any other possibilities.
Rearranging visuals as mentioned by the others to align with the most common end user screen resolution is the most robust approach.
I can think of a couple options that should work without creating a custom HTML/page viewer: require the users to have rectangle monitors that can be rotated from landscape to portrait mode; or set the default report page view value to “Actual size” or “Fit to width” and then have the users toggle the page view to “Fit to page” when they want to see the table at the bottom.
I have one report with a large table at the bottom very similar to yours, and I use the second technique for that one defaulting to “Actual size”.
There is technically one other option, which is to have the users zoom the browser window. I am mainly using Power BI Report Server on-prem, and the report content is not affected by zooming the content in or out (a major pain on small laptop screens). However, I happen to have one Power BI report hosted in the service and sitting on Dynamics/Dataverse. I just checked the browser zoom support both for a direct access report and a report rendered in a Power BI app, and it works! It also only zooms the report page, not the nav pane or filter pane (the exact opposite of on-prem ).
So, you could instruct your users on how to zoom the content in or out as needed to avoid the scrolling. The shortcut key is to hold down Ctrl and scroll your mouse wheel.
).