Forum Discussion
Trying to create a Bubble Chart with two values
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.
Super UserJakeSchmetterer , 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: