Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 56 | |
| 55 | |
| 32 | |
| 18 | |
| 14 |