How to convert column into list of value

[Anonymous]

Hi all,

Currently I already publish a graph but the value of the graph as below (each column each abnormality). Since it input so many column in the values, so I decided to unpivot all the column in power query but did not get the same result. My goals is to use clustered column chart and sort it by value (%) from high to low.

This is the link of the excel - https://docs.google.com/spreadsheets/d/1GecgpPnS3qCWYcd6fOeAer0LSAMMOe7z/edit?usp=drive_link&ouid=116823452117004669194&rtpof=true&sd=true

Regards,

Nuha

[Anonymous · Accepted solution]

Hi @Anonymous ,

After unpivotted, you got a Attribute column and a Value column. Everything seems to be OK.

Is the percentage result you want wrong in your visual? How is your percentage calculated?

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[Anonymous]

Hi @Anonymous ,

Any other way to do this? Since if I unpivot my data, the row of the table will be different. Because in this table not only have 2 column. 

[Anonymous]

Hi @Anonymous ,

Was my reply helpful? If so, please mark it as solution, more people will benefit from it.

Best Regards,

Stephen Tao

[Anonymous]

Hi @Anonymous ,

If you don't want to change the format of your data. What about unpivotting using DAX?

Please refer to

powerbi - Is it possible to unpivot in Power BI using DAX? - Stack Overflow

DAX Unpivot - Microsoft Fabric Community

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.