Forum Discussion
Helper IIHelp with Visualization of values
hi haniizz
Step1: Create a Category table, and sort Category name by sort column(Column tools > Sort By Column).
Step2 :
Create this measure
Measure By Category =VAR _SelCategory = SELECTEDVALUE(Categody[Sort])RETURN IF(_SelCategory = 1, [POVERTY REDUCTION], IF(_SelCategory = 2, [DESEASE REDUCTION], [UNEMPLOYMENT REDUCTION]))Step3 : In a Stacked Column chart, drop Category on X-Axis and New Measure on Y-Axis.Hope this helps.
Solution Sagehi haniizz
Step1: Create a Category table, and sort Category name by sort column(Column tools > Sort By Column).
Step2 :
Create this measure
Helper III don't know how can I thank you enough
this is perfect
you deserve this title ( solution suppliers )
thank you for your patiance and providing solution
- haniizz
Dear Talespin
I have an issue when I add more than 3 elements
when I'm trying to add "Education" to the other three elements I get blank column althought all of the measure is correct- talespin
hi haniizz
- You need to add "Education" to Step1 table.
- You also need to modify this measure, add "Education" to IF and call your measure for education.
Measure By Category =VAR _SelCategory = SELECTEDVALUE(Categody[Sort])RETURN IF(_SelCategory = 1, [POVERTY REDUCTION], IF(_SelCategory = 2, [DESEASE REDUCTION], [UNEMPLOYMENT REDUCTION]))