Making Slicer Out of Overlapping Data

[nikhilbordekar]

Dear Power BI Community,

I'm seeking advice on a challenge I'm facing in my Power BI dashboard. I have a table with RX (numerical) values along with three flag columns: TRx, NBRx, and NRx. Some rows in the table overlap with each other based on these flags.

In my dashboard, I've used RX in almost every chart. Now, I want to implement filtering such that when I select TRx, NBRx, or NRx, it should filter the data in every chart.

I'd appreciate any insights or recommendations on how to achieve this filtering functionality seamlessly across all charts while maintaining the visual formats.

Thank you for your help!

Here all rows are TRx, few are NBRx and Few are NRx, If am selecting a NBRx then in each chart values should filtered based on the slicer selection. Attaching the dashboard image along with this. Tried Parameter approach but cannot change the values in each chart now so looking for any other approach. 

Note: slicer is visible but not functional as all rows are TRx so I have used rx and TRx interchagebly.

[AnalyticsWizard]

To implement seamless filtering across all charts in your Power BI dashboard, you can use the slicer visualization feature. Here’s how you can set it up:

1. Create Slicers: Add a slicer visualization for each of the flag columns (TRx, NBRx, and NRx). This will allow you to filter the data based on the selected flag.

2. Sync Slicers: Ensure that the slicers are synchronized across all pages of your report if you have multiple pages. You can do this by going to the View tab and selecting Sync slicers.

3. Connect Slicers to Charts: Make sure that all the charts you want to filter are using the same data model and are connected to the slicer fields. This connection is crucial for the slicers to control the charts.

4. Test the Functionality: After setting up the slicers, test them by selecting different flags and observing if the charts update accordingly.

By following these steps, you should be able to filter the data across all charts based on the selection in the slicers while maintaining the visual formats of your dashboard. Remember to save your report and publish it to Power BI service to share the updated functionality with others. If you encounter any issues, Power BI’s official documentation and community forums are excellent resources for troubleshooting.

[nikhilbordekar]

Hey thanks for this approach but i have already given a try for this as well but sync slicer approach is good when you have two slicers to sync here we will have 4 slicers to sync 1) slicer which contain all the flags 2) for TRx 3) for NBRx nd 4) for NRx and when you sync all four it gives nothings. If you are confident on this approach please share a dummy file if possible. Thank you!