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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

JakeSchmetterer - You cannot use details with x, y pairs. You would need a column or something to identify check-in or check-out and a single measure that displayed the value you want. Put the check-in/check-out column in your legend. Put your single x measure in your values.

JakeSchmetterer's avatar
JakeSchmetterer
New Member
6 years ago

Thanks for your response. However I my check-in and check-out times are two separate columns. I can't put more than one column into Legend