Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to convert column into list of value

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

 

 

 

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.           

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        Anonymous
        Not applicable
        3 years ago

        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.