Forum Discussion
conditional formatting using bubbles in a table
Hello,
I Want to create a table with budget Data and I want to display the data in bubbles format like the example below. How can I create such a table in PBI desktop?
Thanks in adavance for your help!
@MNOUNY Ok I was luckier once I realized I wanted symbol, not shape for glyph:
I attached the chart file so that I can open it on the site and continue where I left off, and including the PBIX file where I included the visual.
3 Replies
- amitchandakSuper User
Anonymous , You can data bars. I doubt you can bubble.
You can check for custom visual https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
- DataZoeMicrosoft Employee
Anonymous Conditional formatting in a table is fairly easy but I don't think it will do that dot look, which is quite neat.
Closest I could get out of the box was a scatter/slicer option:
But it's not ideal (I had to manually set the x/y axis, and convert the row/column names to number versions, etc. So it wouldn't adjust with more row or column labels. The slicers are kind of neat because it allows you to zoom in a bit tho.
Another option that may get you to the look is https://charticulator.com/ tho it takes me a bit to get it to do what I want, once I do get it, it works really nicely with Power BI. I got this far:
So looks like you could probably get it the rest of the way?