Forum Discussion
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...
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,
KellyDid I answer your question? Mark my post as a solution!
Hi Anonymous parry2k thank you very much for your suggestions. However, in the case where I only have some columns that I would want to include and others that I wouldn't; how could I approach this?
As an example please see the table below:
| Date | Kategories A | Category B | Category C | Sales (never want it to be included) |
| 01/01/2020 | 12 | 21 | 99 | 34 |
| 01/02/2020 | 11 | 7 | 32 | 12 |
| 01/03/2020 | 4 | 45 | 2 | 1 |
Hi Anonymous ，
It doesnt matter,when you are unpivoting columns,you just need to select the column you need,like below:
You would find that sales column wasnt unpivoted.
Best Regards,
Kelly
Kelly
Did I answer your question? Mark my post as a solution!