Forum Discussion

haniizz's avatar
haniizz
Icon for Helper II rankHelper II
2 years ago
Solved

Help 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...
Need Help
  • talespin's avatar
    talespin
    2 years ago

    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's avatar
haniizz
Icon for Helper II rankHelper II
2 years ago

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's avatar
talespin
Icon for Solution Sage rankSolution Sage
2 years ago

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]))
  • haniizz's avatar
    haniizz
    Icon for Helper II rankHelper II
    2 years ago

    thank you 
    issue is solved