topic Re: Clustered bar chart with bubbles for each bar on a 2nd y-axis in Developer

Clustered bar chart with bubbles for each bar on a 2nd y-axis

YevD — Fri, 28 May 2021 19:36:15 GMT

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

Re: Clustered bar chart with bubbles for each bar on a 2nd y-axis

Anonymous — Mon, 31 May 2021 10:00:12 GMT

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

Re: Clustered bar chart with bubbles for each bar on a 2nd y-axis

YevD — Tue, 01 Jun 2021 00:01:20 GMT

Hi @Anonymous ,

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?

Re: Clustered bar chart with bubbles for each bar on a 2nd y-axis

Anonymous — Wed, 02 Jun 2021 03:14:39 GMT

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

Re: Clustered bar chart with bubbles for each bar on a 2nd y-axis

YevD — Tue, 15 Jun 2021 01:53:45 GMT

@Anonymoussorry 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/

Re: Clustered bar chart with bubbles for each bar on a 2nd y-axis

AGaribay7 — Tue, 19 Mar 2024 17:01:26 GMT

Did the article resolve the problem ?