topic Re: Help with Visualization of values in DAX Commands and Tips

Help with Visualization of values

haniizz — Thu, 15 Feb 2024 06:08:47 GMT

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

Re: Help with Visualization of values

talespin — Thu, 15 Feb 2024 14:11:48 GMT

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.

Re: Help with Visualization of values

haniizz — Fri, 16 Feb 2024 00:53:41 GMT

thank you talespin

here is the PBIX file

Re: Help with Visualization of values

haniizz — Fri, 16 Feb 2024 00:59:37 GMT

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

Re: Help with Visualization of values

talespin — Fri, 16 Feb 2024 01:42:23 GMT

hi haniizz

What is the end result that you need?

Re: Help with Visualization of values

haniizz — Fri, 16 Feb 2024 05:43:31 GMT

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

Re: Help with Visualization of values

talespin — Fri, 16 Feb 2024 05:51:53 GMT

hi haniizz

Can you please show visual handdrawn of what you expect.

Re: Help with Visualization of values

haniizz — Fri, 16 Feb 2024 06:19:03 GMT

Hi Talespin

I'm expecting something like what is in this picture

Re: Help with Visualization of values

talespin — Fri, 16 Feb 2024 07:38:58 GMT

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.

Re: Help with Visualization of values

haniizz — Fri, 16 Feb 2024 07:53:37 GMT

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

Re: Help with Visualization of values

talespin — Fri, 16 Feb 2024 07:56:02 GMT

hi haniizz

You're are welcome.

Re: Help with Visualization of values

haniizz — Fri, 16 Feb 2024 09:35:30 GMT

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

Re: Help with Visualization of values

talespin — Fri, 16 Feb 2024 12:11:13 GMT

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

Re: Help with Visualization of values

haniizz — Mon, 19 Feb 2024 03:01:06 GMT

thank you
issue is solved