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 values are measures , and are not from the dataset table

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.

13 Replies

  • talespin's avatar
    talespin
    Icon for Solution Sage rankSolution Sage
    2 years ago

    haniizz 

     

    Please share some sample data, data model or pbix if possible. Please remove any sensitive information, provide mock data that best explains your scenario.

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

    the table ( to be visulized ) contains the 3 measures that I need to visulize it in stacked column chart

    so that ( poverty reduction , desease reduction , unemployment reduction ) are in x axis ,, and their values are in y axis

    the pbi file is from here

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

      I 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