How to display only 3 regions out of 5 in a bar chart

[Sudheerk18]

Hi All,

Regions - A,B,C,D,E and I want to display only A,B,C regions on X-axis of Bar chart. Tried below formulas but no luck.

1) IF([Region]='A' or [Region]='B' or [C]='C',[Region],null())

2) only({<[Region]={"A","B","C"}>}[Region])

Can someone help please.Thanks in advance.

[albertovarela · Accepted solution]

You can control that through your measure.

Let's pretend your measure is Sum(Sales) then you can use:

Sum({$<Region={'A','B','C'}>}Sales)

I hope this helps

[albertovarela]

Another way would be Aggr(if(match(Region,'A','B','C'),Region,null()),Region) . Just make sure to remove the nulls.

[Sudheerk18 · Accepted solution]

Thanks AlbertoV. Your first solution worked. 🙂