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.
Hello,
I've got a clustered column chart with categories on axis, and a measure which counts active items
My goal is to hide categories where measure is less than 10
When I use filters on visual from measure and set greater or equal to 10, then the measure of >=10 categories decrease, like it took something out of it. I've tried INT ( [measure] >=10 ) and set it to 1.
Hi @Pbiuserr ,
Has your problem solved by @amitchandak 's solution? By my test it works fine. If so, would you mind accept his reply as solution? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.
Best Regards,
Kaly
No to the extend I would like to. This measure>10 is known solution and it works but slows down the performance. I wanted this on a drillthrough tables, whereas there are several measures
@Pbiuserr , Use a visual level filter [Measure] > 10
doesnt work for me, especially if i got "show as % of total" then changes %. but it also changes the whoel numbers in a chart, dont know why
@Pbiuserr , Another option is , assume you have measure m1 and column c1 used in visual
Sumx(filter(Summarize(Table,Table[Column]), [M1] >10), [M1])
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 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |