Forum Discussion
How to dynamically display the values in slicer based on the selection of another slicer
Thanks for the reply from bhanu_gautam .
I did a test using sample data of Power BI for your reference.
I'm using the country field in the table as Slicer1.
Then five measures are created as parameter(Slicer2)
Then I entered the table shown in the image below as an intermediate table for connecting the data table and parameters.
Output:
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserEnsure that there is a relationship between the Engagement Model table (used in Slicer 1) and the tables used for Slicer 2 and Slicer 3. This relationship will help filter the data based on the selection in Slicer 1.
Create new tables using DAX that dynamically filter the metrics based on the selected Engagement Model. These tables will be used for Slicer 2 and Slicer 3.
For example, if you have a table named Metrics that contains all possible metrics, you can create a filtered table like this:
FilteredMetrics2 =
VAR SelectedModel = SELECTEDVALUE(EngagementModel[Model])
RETURN
FILTER(Metrics, Metrics[Model] = SelectedModel)
Repeat a similar step for Slicer 3.
Use the Filtered Tables in Slicers: Replace the original tables in Slicer 2 and Slicer 3 with the newly created filtered tables (FilteredMetrics2 and FilteredMetrics3).
Sync Slicers (if needed): If you need the slicers to be synchronized across different pages, use the Sync Slicers feature in Power BI.
bhanu_gautam ,
But the two other slicers(slicer2 and slicer3) are manually created paramter table, then how to establish the relationship for slicer1 and others?
Thanks for the reply from bhanu_gautam .
I did a test using sample data of Power BI for your reference.
I'm using the country field in the table as Slicer1.
Then five measures are created as parameter(Slicer2)
Then I entered the table shown in the image below as an intermediate table for connecting the data table and parameters.
Output:
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.