Forum Discussion
Anonymous
6 years agoNot applicable
Values from different columns in one graph
Hello,
I have a query where I got multiple colums with name values.
For example like this:
| Date | Column 1 | Column 2 | Column 3 |
| 1.1.2020 | fish | turtle | turtle |
| 2.1.2020 | turtle | turtle | turtle |
| 3.1.2020 | horse | horse | fish |
| 4.1.2020 | horse | fish | turtle |
How can I create a graph where I have one for each value?
Hope this is understandable as I am new to the topic 🙂
I was not able to find a similar question..
Thank you very much.
Best Regards,
NN
- unpivot your categorical column (turtle fish etc) in power query and have it as one column
3 Replies
- AnonymousNot applicable
Worked like a charm!
Thanks for the fast help guys!
- vanessafvg
Community Champion
unpivot your categorical column (turtle fish etc) in power query and have it as one column - amitchandak
Super User