Ribbon chart to show both value and percentage.

[anvikuttu]

Hi Team,

Below are 2 ribbon charts. Chart A is plotted with values and Chart B shows the same values in percentage of the catogories.

Both the charts are correct in its own way, however i want to show only one chart ie. Chart A but the label should show both values and percentage of the categories. like for eg 5,721(40%). I tried using Dax Studio, failed miserably. 

Could anybody help me with this problem?

Thank you.

Chart A

Chart (B)

[samdthompson]

Hello, I dont believe there is a way to achieve what you are looking for. The closest would be to put the other measure in the tooltips so users would see it on hover.

[anvikuttu]

Thanks for your quick reply @samdthompson 

Yes, as you rightly confirmed my thought that there is no direct solution as there is no control on Y axis, i was looking more on out of box solution.

1. Can the new Charticulator in Power BI desktop help to recreate a ribbon chart from scratch?

2. Is there any other chart which helps on this requirement?

Thank you.

[samdthompson · Accepted solution]

I have had some success with the Charticulator but just playing around with it. Nothing done in anger yet.

Its an inellegant solution but I have had success with overlaying one chart on another with the transparency set to 100% other than key parts. Its not great but I try to stay away from third party visuals after getting burnt a few times.

[anvikuttu]

Wish there was an alternative solution. I am are too pampered by the flexibility of excel, that i see new products from Microsoft through the lens of excel.

[phbronson]

I am looking through the same lenses as you at the moment. So far alot of things are harder to do / not supported in BI that were done in excel native visualization utilizing power query, and power pivot. So far the only benefit for the move to BI for me is ease of hosting and drilling into the data on the front end. I was ok coding my line axis to work with a pareto but not being able to have a bar/line graph with line on seperate axis is a bit of an eye roll