Forum Discussion
Solved
Creating a chart using the same legend to different columns
Hello! I've just started to use Power BI to create dashboards and I have a big issue to solve. My table is like this: ID Q1 Q2 1 Yes Yes 2 Yes Yes 3 Yes No 4 No ...
Look at ALL my responses in this post (you will have to unpivot)
http://community.powerbi.com/t5/Desktop/Multiple-Stacked-Bar-Charts/m-p/111938#M47176
EDIT:
Its really very easy - click Edit Queries
In the Query Editor => select the ID Column => Transform tab => Unpivot Columns => Unpivot Other Columns
Now double click on the new column names and rename each => then Home tab => Close & Apply
build your chart!
That's it!
Good Luck! :smileyhappy:
Hi lia_viegas,
I agree with Sean that the Unpivot option may be the best choice in this scenario. And I don't think 60000 lines could be a problem. It's worth a try.:smileyhappy:
Regards
Ok!
Let's try 8D
thanks a lot!