Michael Bekiares
asked on
PowerPivot Pivot Table Slicers no longer cross filtering
I built a dashboard with a facts table and a few dimension tables loaded into the data model with relationships declared.
After some development, the slicers stopped cross filtering each other.
The slicers still work - they just don't affect each other's content anymore.
I don't recall changing any settings that would cause this.
Is this is corruption?
Anything I can do short of rebuilding?
After some development, the slicers stopped cross filtering each other.
The slicers still work - they just don't affect each other's content anymore.
I don't recall changing any settings that would cause this.
Is this is corruption?
Anything I can do short of rebuilding?
Tom Farrar
Are the slicer fields coming from the dimension tables?
ASKER
Yes, they are. If I use the keys from the data table as slicers instead, they DO cross filter. But when I use slicers from the dimension tables they don't. If I recreate the workbook, they work fine. But that's a pain, of course. Ideally I don't want to have to deal with this situation again.
Did you build the dashboard using the Power BI tool?
Is it possible to delete the slicer(s) and add it (them) back?
Also, this link might be helpful in explaining how slicers work, and how they can be synced....
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
ASKER
This is PowerPivot in Excel, not PowerBI. I have confirmed that it is related to the introduction of a specific measure. As soon as that measure goes into a pivot table, the slicer breaks. If I remove the measure, delete the slicer, then recreate it, things work again.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry for the long silence. What's happening more precisely is that I have multiple slicers, each from different dimension tables. Ideally when a filter is applied from a slicer, it should knock out all the options in the other slicers that are no longer logically available. And it does indeed do that, until I introduce a specific complex measure. I guess something in the measure formula is creating a break in the logical cohesion of the slicers. I think I'll move on from this and revisit it again when I reach a deeper understanding of DAX.