Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I need to make bar charts with group(measure)/shops(dimension-stack)/sell(dimension-bar).
I have 5 groupings and I need to make 5 charts, each for a different group. Unfortunately the groups are stacked together and I can make one graph and then have the user filter, but that's not the point.
There must be 5 plots, each for a different group (Group A, B, C....), and I can't separate the group by Data Load Editor.
So how to make a permanent filter on a chart without using Data Load Editor and Alternate States?
I need some expresion in measure but what i try dont work.
Use this in your measure for each chart in set expression Sum({<Group={'Group1'}>} Sales)
This way you will have 5 different charts 1 for each Group.
Use this in your measure for each chart in set expression Sum({<Group={'Group1'}>} Sales)
This way you will have 5 different charts 1 for each Group.
Thx for help.
I use this code and works.
PS: also this code work in the dimenstion-bar:
=if(wildmatch(Group,'Group1'),Group)