Clustered Column Chart - Secondary Value as a label

I have a Clustered Column Chart that shows % Change on my top 5 items.

I want to a secondary label that shows % of grand total that particular item represents.

Example, Item 1 bar chart shows up 50%, and represents 24% of the total volume.

This secondary value is just an additional data label, hopefully that makes sense.

Is this possible?

@Despo
Can you share a sample pbix file and excel file to work with?

@Despo,

There’s a way to do this, but it’s sort of a ridiculous kludge:

Basically, what you need to do is make two copies of the visual exactly overlaid on top of each other. For the first one, put the data label in the center of the bar, and for the second one put it on top. Then, using the Format, Bring Forward command – bring the one with the label in the center of the bar to the front, and turn on the Maintain Layer Order option, to make sure that it looks right in the service. Here’s how it should look:

Note that it helps to label each chart to keep track of which one is which in the selection pane:

image

I hope this is helpful.

  • Brian
2 Likes

Hadn’t thought of this one, phenomenal ingenuity.

As a side note I did find a marketplace visual called “Line and stacked column chart with table”

That will add below the chart a table/grid view of the data. Then I just turned off the color for the secondary calculation in the axis. Not the best looking visual but it helps keep me from having two seperate visuals and worrying about them getting out of alignment as the axis’s changes.

@Despo,

There’s actually a way to handle the shifting axis problem by overlaying a column and line chart on top of another column and line chart in the same way as above, and then setting transparent backgrounds, transparent line colors in the different visuals, etc. to give the desired effect, but if you’ve got a custom visual that does all that without all the rigmarole, that’s probably the way to go.

  • Brian