Forum Discussion
haniizz
Helper II
Helper IIHelp with Visualization of values
Hello community I have measures values as following Poverty = 45% Disease = 62% unemployment = 33% I need to visualize this in Stacked Column Chart how can I do this , knowing these v...
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.
haniizzHelper II
Helper III need to visualise this way
every category in a column , so in X axsi we have three values ( poverty reduction - health reduction- unemployment reduction ) three columns , not three in one column is you have shared
- haniizz
Hi Talespin
I'm expecting something like what is in this picture- talespin
Solution Sage
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.- haniizz
I 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