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

[YevD]

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

[v-yiruan-msft · Accepted 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-msft]

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

[YevD]

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?

[v-yiruan-msft · Accepted 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

[YevD · Accepted solution]

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

[AGaribay7]

Did the article resolve the problem ?