Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamically including columns in stacked column chart

Hi all!    I have an input table of the format:   Date Category A Category B 01/01/2020 12 21 01/02/2020 11 7 01/03/2020 4 45   From which I create a stacked column chart...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi  Anonymous ,

     

    Yes,you should unpivot all the category columns into one column that it will automatically apply for the changes:

    Steps are as below:

    Go to query editor>select category columns>unpivot:

    And you will see:

    For the related .pbix file,pls click here.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

     

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous you should unpivot your data

 

- transform data
- select date column in your table
- right-click, unpivot other columns it will add two columns, attribute, and value, rename these as per your requirement
- close and apply

To visualize,
- date on x-axis

- attribute on legend

- value on values section

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡