How to make expressions look like dimension???

[#1]

Hi Everyone ,

I have 5 measures and one dimension with 2 values in it . I want output like this

Whereas I am getting this

Any help is greatly appreciated...

[Gysbert_Wassenaar · Accepted solution]

See attached example.

edit:

1. Add your dimension with the two values
2. Add a calculated dimension using the valuelist function: =ValueList('Max','Min','Avg','Median')
   Max, Min etc are just example labels. Replace them with the labels you want to see in your chart
3. Add an expression like:
   pick(match(ValueList('Max','Min','Avg','Median'),'Max','Min','Avg','Median'),max(Sales),min(Sales),avg(Sales),median(Sales))
   replace the labels Max, Min etc again with your labels. Replace max(Sales), min(Sales) etc with the expressions you want to see as 'dimensions'.
   
   
   

[#3]

Hi Gysbert ,

Actually my license expired few days back so I am unable to open your file , can you please write down how you are doing?

[#4]

Hi Gysbert ,

Thanks I think that will work but right now chart says "allocated memory exceeded", Why is this coming up?

[#5]

Thanks Gysbert ,

That was my mistake I just forgot one bracket. Thanks again you saved my day. Lot of cheers...