Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.