Help with Visualization of values

[haniizz]

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

[talespin]

hi @haniizz 

What is the end result that you need?

[haniizz]

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

[talespin]

hi @haniizz 

Can you please show visual handdrawn of what you expect.

[haniizz]

Hi Talespin

I'm expecting something like what is in this picture 

[talespin · Accepted solution]

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

[talespin]

hi @haniizz 

You're are welcome.

[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]))

[haniizz]

thank you 
issue is solved

[haniizz]

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

[talespin]

@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]

thank you talespin

here is the PBIX file