Values from different columns in one graph

[Anonymous]

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

[Anonymous]

Worked like a charm!

Thanks for the fast help guys!

[amitchandak]

@Anonymous , Unpivot

https://radacad.com/pivot-and-unpivot-with-power-bi

[vanessafvg · Accepted solution]

unpivot your categorical column (turtle fish etc) in power query and have it as one column