How can I built a correct Bubble Chart with on the x-axis the date and on the y-axis time duration (time difference between "Mail Incomen" and "Mail Return")? I know you can do this in Excel (see picture below), but how can you fix this in Power BI?
On the y-axis I use (on the date of 08-04-2020) for example 1:24 (= 1 hour and 24 minutes) = 124. This is probably not the correct way, but it is a little bit creative. I want to see values on the y-axis like they have in Excel (HH:MM). In Power BI I have set the value on the y-axis on "Average" (Data in the column "Time"). The number that now will display on 08-04-2020 is 175 (the average -> 2*124 + 2*226 / 4). Actually I want to see two dots in the bubble chart on that day, two clustering of 1:24 (124) and two clustering of 2:26 (226) -> just like in Excel. What can I do to fix this problem in Power BI?
On the x-axis I also want a date interval of 5 days instead of showing the date by data point (see picture below) -> how can I fix this issue?
My Bubble Chart example in Power BI
Piece of data in Power BI for the Bubble Chart
Piece of data in Power BI for the Bubble Chart to copy and paste
| Date | Contract | Amount | Type | Fine Status | Mail income | Mail return | Difference | Time | Index |
| 08-04-2020 | A | 5110 | Elek | Indicatief | 08-04-2020 08:54:00 | 08-04-2020 10:18:00 | 01:24:00 | 124 | 0 |
| 08-04-2020 | B | 988 | Elek | Indicatief | 08-04-2020 08:54:00 | 08-04-2020 10:18:00 | 01:24:00 | 124 | 1 |
| 08-04-2020 | C | 989 | Gas | Indicatief | 08-04-2020 14:25:00 | 08-04-2020 16:51:00 | 02:26:00 | 226 | 2 |
| 08-04-2020 | D | 6401 | Gas | Indicatief | 08-04-2020 14:25:00 | 08-04-2020 16:51:00 | 02:26:00 | 226 | 3 |
| 21-04-2020 | E | 5345 | Elek | Indicatief | 21-04-2020 10:47:00 | 21-04-2020 16:35:00 | 05:48:00 | 548 | 4 |
| 21-04-2020 | F | 10621 | Elek | Loss | 21-04-2020 10:47:00 | 21-04-2020 16:35:00 | 05:48:00 | 548 | 5 |
If the Bubble Chart is not the correct chart to use for my data than what will be a good alternative?
Thanks for the help
The core issue here is that you are already using the "Fine status" column as the legend for the bubble chart. Having several different datapoint on a single X-value can only be done by implementing a legend.
Currently you a displaying a datapoint for each fine status value that can be found in the related date. If you feel that you can replace the fine status legend you can use the "time" column instead to get the desired values:
As for the dates the most simple soution is to just group it by week. If this is applicable you can just use a new column:
Week = WEEKNUM(Table[Date] , 2)
If you need exact 5 day intervals then it becomes a little more complicated, let me know if that's the case.
/ J
The core issue here is that you are already using the "Fine status" column as the legend for the bubble chart. Having several different datapoint on a single X-value can only be done by implementing a legend.
Currently you a displaying a datapoint for each fine status value that can be found in the related date. If you feel that you can replace the fine status legend you can use the "time" column instead to get the desired values:
As for the dates the most simple soution is to just group it by week. If this is applicable you can just use a new column:
Week = WEEKNUM(Table[Date] , 2)
If you need exact 5 day intervals then it becomes a little more complicated, let me know if that's the case.
/ J
Helpful resources
Fabric Community Update - July 2025
Find out what's new and trending in the Fabric community.
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.
