Forum Discussion
Attribute not Filtering in Slicer
Good afternoon,
I have an attribute in a hierarchy that filters correctly in Excel when another attribute has a value selected, but is not filtering in Power BI.
As an example, I want to look at the 2018 Academic Year and I want all the offerings from that academic year displayed as a slicer. In this example, to make it clearer how Excel and Power BI differ, I will show the offerings in a table.
Here is Excel; you can see, by the year in the Description, that the offerings are filtered for 2018:
However, in Power BI, this is what I get; you can see ALL years are returned:
If I turn the slicer into a table and add a Measure, it does filter:
Is this expected behaviour? Some of my fields are filtering in Power BI based on Academic Year -- this is the only one I've seen that won't filter as a slicer in Power BI, but as above it does work in Excel [note: I am not showing any measures in Excel].
Thanks,
Ian.
Hi Anonymous ,
Could you please check if your relationship is correct with your different tables, you could refer to below link about the relationship:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
If it could not help you, I suggest you share your pbix file to have a test if possible.
Regards,
Daniel He
Hi Anonymous ,
Ok, if your problem could be solved, don't forget to mark one reply as answer to close this topic.
Regards,
Daniel He
5 Replies
v-danhe-msftMicrosoft Employee
Hi Anonymous ,
Could you please check if your relationship is correct with your different tables, you could refer to below link about the relationship:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
If it could not help you, I suggest you share your pbix file to have a test if possible.
Regards,
Daniel He
- v-danhe-msft
Hi Anonymous ,
Ok, if your problem could be solved, don't forget to mark one reply as answer to close this topic.
Regards,
Daniel He