Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
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.
@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
@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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |