Hide a bar from visual only but consider it in the calculation

[Saniat]

Hi,

I have 100 records each belong to a category.

ID,Category
101,A
102,A
103,B
....
200,D

I have plotted them in bar chart and showing as % of grand total.

I want to remove one category from 'visual only'. This means that category should be counted in the overall % calculation, but will not be shown in the visual.

Can I achieve that ?

[_AAndrade]

Hi,

Please could you share your measures and the how you build this chart?

I think you could do this using a IF statement, but I need to see the information above to think how to do it.

[Saniat]

@_AAndrade , hi, no measures created, just brought the field into visual and applied native calc to show as % of grand total.

[_AAndrade · Accepted solution]

Please see this measure:

You'll probably have to adapt this part "COUNT(T_Data[ID])/100" according to your model, but the logic is this.