Forum Discussion

JakeSchmetterer's avatar
JakeSchmetterer
New Member
6 years ago
Solved

Trying to create a Bubble Chart with two values

Hello,   The following bubble chart was created by someone using a program that was not Power BI: I want to recreate it but in Power BI. Here is what I have managed to do so far: I pu...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi JakeSchmetterer ,

     

    You may go to Query Editor, select on the two columns [Check-In Time (bins)] and [Check-Out Time (bins)] in the meantime, right click to choose option "Unpivot columns",  then you can rename the result column Attribute with "Check Time" ,don't forget to click button " Close & Apply" .  After that, you may put [Check Time] column into Legend box .

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi JakeSchmetterer ,

 

You may go to Query Editor, select on the two columns [Check-In Time (bins)] and [Check-Out Time (bins)] in the meantime, right click to choose option "Unpivot columns",  then you can rename the result column Attribute with "Check Time" ,don't forget to click button " Close & Apply" .  After that, you may put [Check Time] column into Legend box .

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.