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!

     

Anonymous's avatar
Anonymous
Not applicable
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!