Do not display category on visual if under certain amount

[Pbiuserr]

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.

[Kaly]

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

[Pbiuserr]

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 

[amitchandak]

@Pbiuserr , Use a visual level filter [Measure] > 10

[Pbiuserr]

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

[amitchandak]

@Pbiuserr , Another option is , assume you have measure m1 and column c1 used in visual

Sumx(filter(Summarize(Table,Table[Column]), [M1] >10), [M1])