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.
Is there a way to filter our columns in a bar chart without affecting the calculation? For instance, I have 10 production loss categories, but I only want to show the top 4. The loss columns are on the Axis, but anytime I filter our the ones I don't want to show, it recalculates the percentages. Is there any way to avoid this?
Thanks
Jacob
Hi @Anonymous,
Take the following table for example, firstly create new columns using DAX below in the table.
%pecentage = 'Table'[Amount]/SUM('Table'[Amount])
RankColumn = RANKX(ALL('Table'),'Table'[%pecentage],,DESC)
Secondly, create bar chart using ProductSubcategory and %pecentage, then drag RankColumn to Visual level filters and set the value of RankColumn to “is less than or equal to 4”.
If the above steps doesn't help, please share sample data of your table here.
Thanks,
Lydia Zhang
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |