Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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
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
Thanks Daniel. As I'm using a Live connection, I cannot access the "Relationships" -- it is greyed out.
I'll see what I can do re a sample file...the data is rather confidential.
Ian.
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
Hi Ian,
I have not worked long with Power BI. But I guess you need to make sure that the table underlining Year should have clear relationship with all other tables being referred to by this chart.
Hope this help.
Regards,
Tracy
Thanks Tracy; it seems to as it works in Excel... But something to check with the developers -- thanks.
Ian.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |