Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I am trying to figure out why clicking on a section of a stacked column chart is not fully filtering a table on the same page. It shows it as part of the filter of the table, but it is only filtering on the column and not the data part that is sorting the stacked column. For example, the stacked chart is sorted by rating and the columns are different categories. When clicking on say a rating of 5 for category A in the stacked column, it should show only the items from category A with rating of 5, but ALL of the ratings are appearing in the table. The filter shows that it SHOULD be filtering, but it does actually filter it. I have a screenshot below where it shows the rating as being part of the filter, but it is not actually filtering on the rating AND the category. It is ONLY filtering on the category and showing all the ratings in the table. If we click on the rating in a slicer, it filters correctly, but not if you click in the stacked column chart. Please let me know if you need more information, but I hope this is an easy fix or a bug and not working as intended. Thank you!
Solved! Go to Solution.
I finally figured it out. I had only single direction for the relationship between two tables to the main table. I needed to change it to bi-direction. That made it work!
I finally figured it out. I had only single direction for the relationship between two tables to the main table. I needed to change it to bi-direction. That made it work!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |