Forum Discussion
AMitchell
10 months agoFrequent Visitor
Ribbon Chart Total Labels
I have a ribbon chart showing the Total Labels above each column. When using slicers the Total Labels update as I would expect to show the filtered total. However, when i select within the ribbon cha...
- 10 months ago
Hi AMitchell
Okay, gotcha. I see the challenge. Unfortunately, the ribbon chart does not natively allow you to adjust the value of the total as it is meant to add up the segments together. However, you can achieve a similar effect by stacking two visuals on top of each other (and then grouping it).
Here's a basic approach that would work:
- Switch to the stacked bar chart. Don't worry you, can always toggle the "ribbon" setting to make it look exactly like the ribbon chart.
Note: Stacked bar, not 100% stacked bar chart. - Visual 1: Drop your segment in the Legend field. Format as needed.
- Visual 2: Copy visual 1 and remove the column from the Legend field. This will convert the visual into a single column. You're then going to format and turn on data labels and/or total labels. Format all elements except your total number to be transparent.
- Next, click visual 1 and click FORMAT and click EDIT INTERACTIONS. Instead of it highlighting, select FILTER on visual 2. This will ensure that your bar does not move.
- Final step is to overlay one over the other.
- Switch to the stacked bar chart. Don't worry you, can always toggle the "ribbon" setting to make it look exactly like the ribbon chart.