Forum Discussion
Leowp
2 years agoFrequent Visitor
Incorrect total in stacked bar chart
Hello, I'm trying to display the "Total sales $" for all segments using a stacked bar chart with a line, but the value displayed is incorrect. I want to show the sum of all segments, but the value ...
vanessafvg
Community Champion
2 years agohave you got the total label switched on or the data label?
Leowp
2 years agoFrequent Visitor
The issue is on the total label, i don't want to use the data labels.
In my tests, the problem only occours when i put a measure in the visual, if i use the column and agreggate with sum, the problem doesn't occours.
- vanessafvg2 years ago
Community Champion
what is your measure?
- Leowp2 years agoFrequent Visitor
I think the problem is in the dynamic format string, if i remove that from the measure, it works normally
Heres the link to the example .pbix
- vanessafvg2 years ago
Community Champion
can i just confirm what you are trying to achieve with the dynamic string?