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 and thank you for giving this a look.
I am trying to re-create the chart I made in Excel below in PowerBI, so far with little success.
Sample pbix file is below. I need to display count of 'Name' for each 'Amount' bucket in the clustered columns on first y-axis. The second y-axis should display average 'Cost' for each bucket in the bubbles/dots. X-axis contains 'Date 1'.
https://1drv.ms/u/s!AgeVqxpmuh7I9QSR6U7kLYAmLwga?e=4jaIjX
Any help will be greatly appreciated.
Cheers!
YevD
Solved! Go to Solution.
Hi @YevD ,
I can't find the proper visual which same with the one in report page "Stacked chart w XY bubbles". I reupdate your sample pbix file(see the attachment), please check whether that can be used for a workaround... And currently we CAN NOT apply multiple fields on Legend Fields, you can raise a new idea and add your comments there to make this feature coming sooner.
Best Regards
@v-yiruan-msftsorry for taking a while to get back to this. I really appreciate your help!
I actully found an article descirbing how to do this with R.
https://datakuity.com/2020/12/03/r-power-bi-add-target-marker-to-each-column-in-a-grouped-bar-chart/
Hi @YevD ,
I updated your sample pbix file, please check whether that is what you want, please find the details in the attachment.
Best Regards
Hi @v-yiruan-msft ,
Thank you so much for this. The grouping of amount is eaxactly what I was looking for. Do you know if there is a way to display average of 'Cost' for each bar?
Also, is there a way I can sort the groups in ascending order?
Hi @YevD ,
I can't find the proper visual which same with the one in report page "Stacked chart w XY bubbles". I reupdate your sample pbix file(see the attachment), please check whether that can be used for a workaround... And currently we CAN NOT apply multiple fields on Legend Fields, you can raise a new idea and add your comments there to make this feature coming sooner.
Best Regards
@v-yiruan-msftsorry for taking a while to get back to this. I really appreciate your help!
I actully found an article descirbing how to do this with R.
https://datakuity.com/2020/12/03/r-power-bi-add-target-marker-to-each-column-in-a-grouped-bar-chart/
Did the article resolve the problem ?
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 |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |