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 Sales fact table and dimenson for Sales Rep and another dimension for Customer.
One slicer has Sales Rep Names from Sales Rep dimension and another slicer is Customer Name from Customer Dimension table.
When a Sales Rep is selected I only want the Customer slicer to show relevant customers for that rep.
Is there a way to achieve this without enabling bi-directional cross filtering?
I heard enabling below option is a bad idea:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-bidirectional-filtering
Solved! Go to Solution.
Hi @acbg ,
For filtering slicers, you could try like this:
Measure = INT ( NOT ISEMPTY ( 'Sales' ) )
https://www.sqlbi.com/articles/syncing-slicers-in-power-bi/
If you need to do calculations, you could use CROSSFILTER function.
Hi @acbg ,
For filtering slicers, you could try like this:
Measure = INT ( NOT ISEMPTY ( 'Sales' ) )
https://www.sqlbi.com/articles/syncing-slicers-in-power-bi/
If you need to do calculations, you could use CROSSFILTER function.
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.