Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
MontyDogar
Frequent Visitor

Show / Hide Visuals on all Report Pages based on selections on Page 1

Hi Experts, 

For a retail usecase, my clients have different week cycles, some want to see the data Mon to Sun or Tues to Mon and so on. 

 

I have been trying to create a "Settings" page in the report. On this page, clients can choose their "Week cycle ends on" day. This should now change / show / hide visuals on other report pages. 

 

Note - I have tried buttons / selection / bookmarks, but that route requires selection to be done on each report page, which is not desired. 

 

Looking forward

1 ACCEPTED SOLUTION
MontyDogar
Frequent Visitor

Found a solution. This works

https://community.powerbi.com/t5/Desktop/How-to-change-measure-value-using-parameters/m-p/46065#M179...

 

The only additional thing I did was to copy the slicers to all the pages with Sync Enabled and then "hide the copied slicer". Now the first page acts as the settings page. When I set any value there, its replicated across all pages. 

View solution in original post

3 REPLIES 3
MontyDogar
Frequent Visitor

Found a solution. This works

https://community.powerbi.com/t5/Desktop/How-to-change-measure-value-using-parameters/m-p/46065#M179...

 

The only additional thing I did was to copy the slicers to all the pages with Sync Enabled and then "hide the copied slicer". Now the first page acts as the settings page. When I set any value there, its replicated across all pages. 

Portrek
Resolver III
Resolver III

Hi MontyDogar.

 

Maybe you can use the RLS - Row Level Security for determinate what each client can see.

look this video below, it's can help you

https://www.youtube.com/watch?v=nAePfbGOEQE

Another possibilitty is define the parameters through bookmarks associated with buttons for each customer

Look that https://www.youtube.com/watch?v=ETLxAxb3gZk

 

I wait to get help tou.

 

Best regards.

Unfortunately neither help my situation. Let me explain a bit. 

On each report page I have 2 set of visualizations built using different tables. I could have used RLS if the table was same. I need to show / hide one set of graph based on the user preference. 

 

Worst case, I will need to put a button on each report page and use bookmarks but that's inefficient. Any other possibility. Ideally I place a button on first page (settings page) and that hides one set of visuals on all report pages. 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.