Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a report with mulitple slicers. These slicers filter a measure called sales. I want the last slicer region to be dependant on the actual regions which exist in the sales after the sales is filtered by other slicers.
Dimension region
Dimension A
Dimension B
Fact Sales
So dimension A and B filter the fact sales, and the last slicer is region. For now it shows all regions but i only want the regions which are truly related to the residing sales. I do not want a solution which pertains the region inside the sales fact group I consider it unnecessary duplication.
Solved! Go to Solution.
Hi Giovi2008,
One way I use for exactly what you descibed is to do a calculated column with RELATED() in the sales data table that pulls the region. Then create the slicer with the region column just created. That way it would work as you described.
Another way you can test, is to set the relationship between the region dimension table and the sales table as both direction.
Cheers.
Hi Giovi2008,
One way I use for exactly what you descibed is to do a calculated column with RELATED() in the sales data table that pulls the region. Then create the slicer with the region column just created. That way it would work as you described.
Another way you can test, is to set the relationship between the region dimension table and the sales table as both direction.
Cheers.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |