Trying to create a Bubble Chart with two values

[JakeSchmetterer]

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 put Check-In Time and Check-Out Time in the X-Axis but I can't get them both to show up at the same time. I can toggle between the two by drilling down, but that's now what I want. I want to see the check-in times in blue and check-out times in organe all on the same graph. Is this possible with Power BI?

[v-xicai · Accepted solution]

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]

@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]

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

[amitchandak]

@JakeSchmetterer , The above one is using a time bucket.  And legend. Top right corner showing legend.

First, try legend, and they try a time bucket.

Time table of which you can create time bucket

https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

[JakeSchmetterer]

Legend wont work beause I can't put both my check-in column and check-out column in there, it only accepts one.

I did create a Time Table and it looks like this:

This is what my other table looks like:

I have connected them as such:

But I cannot figure out how to make this graph work... This is what I have: