Forum Discussion
different layout for different field value
hello powerBI gurus,
need some urgent help with this:
i want to create a customer info report. For customer different regions, the report has total different layout. i want to have a slicer or sth like this first for selecting different customer. And then if the customer is from i.e. US then the report will show certain layout, if i select another customer who comes from UK then the viewer could see another different layout. I need some general idea about how to accomplish it.
thanks in advance.
Hi iris0113 ,
You may create bookmarks for every country selected options, for the customers at UK, you may set hide all the visuals of 6th page in Selection pane.
For references:
Use bookmarks to share insights and build stories in Power BI ,
Dynamic Visuals using Buttons.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
For different layouts, you'll need separate report pages (or a lot of show/hide functionality with bookmarks on a single page). Please see this video on how to use buttons for page navigation. They can now be dynamic with the use of an expression (that you should be able to tie to your slicer selection).
https://www.youtube.com/watch?v=nCEMM6Ryees
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
thanks for your reply first. but my problem is now in my example, for customer located at USA, i have 6 report pages and for customer at UK i only have 5 of them. i guess there is no way to dynamically hide the page with bookmarks.
iris0113 ,
Try if bookmarks can help you on that
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Hi iris0113 ,
You may create bookmarks for every country selected options, for the customers at UK, you may set hide all the visuals of 6th page in Selection pane.
For references:
Use bookmarks to share insights and build stories in Power BI ,
Dynamic Visuals using Buttons.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
