Forum Discussion

lia_viegas's avatar
lia_viegas
Regular Visitor
9 years ago
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 ...
Need Help
Sean's avatar
Sean
Community Champion
9 years ago

lia_viegas

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:

 

 

lia_viegas's avatar
lia_viegas
Regular Visitor
9 years ago

Hello, Sean,

 

Thanks for your answer and sorry for my late reply.

 

So the only thing I can do is what you suggested? What will happen if in the case I must update the data table every week?  My table is kind of big (2000 lines/month, 30 columns), so after unpivoting columns I'll have 60000 lines, will it be a problem?

 

Thanks again!

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    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

    • lia_viegas's avatar
      lia_viegas
      Regular Visitor
      9 years ago

      Ok!

       

      Let's try 8D

       

      thanks a lot!