Forum Discussion
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 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?
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.
5 Replies
- amitchandak
Super User
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/
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:
- Greg_Deckler
Community Champion
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.
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
v-xicaiCommunity Support
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.
