Forum Discussion
Tricky stacked chart situation
Dear community,
below is one of my visual
and below is what i am trying to achieve, unfortunately my client requirement is to get a total on top of the chart see below
let me know how to achieve this in power BI?
Hi vjnvinod
Here is a workaound:
Create a measure to show the total
Measure = CALCULATE(SUM(Table1[value]),ALLEXCEPT(Table1,Table1[x axis]))
Add this measure in the line values in the line and stacked column chart
In Data labels, Position -"inside end", shapes-"stroke width is 0"
You could download my pbix for more details.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi vjnvinod
Here is a workaound:
Create a measure to show the total
Measure = CALCULATE(SUM(Table1[value]),ALLEXCEPT(Table1,Table1[x axis]))
Add this measure in the line values in the line and stacked column chart
In Data labels, Position -"inside end", shapes-"stroke width is 0"
You could download my pbix for more details.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.I think it is not possible.
But a workaround could be to use a card visual on top of each category
but this is not a constant value, as this might keep changing, so next time i will again has to fix the alignment
