Forum Discussion
adding data labels to 100% stacked bar chart
hi
I would like the bar to not only show % of total, but also the name of category next to it (very similar to detail labels in pie chart)
how can I do that?
Hi, fsfs ;
You could add custom power bi visual as follows:
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
- amitchandak
Super User
fsfs , You need to use a measure that % percent. If you want to show percent
Assume you have measure
Axis is using col1
then use measure
divide([measure], calculate([measure], filter(allselected(Table), Table[Col1] = max(Table[Col1]))))
if need use a stacked line and show measure
calculate([measure], filter(allselected(Table), Table[Col1] = max(Table[Col1])))
on that and show labels and change line color same as background color
- v-yalanwu-msft
Community Support
Hi, fsfs ;
According your description, you could create a measure to calculate the percentage of every category. I create a simple example and create a measure as follows:
sales%1 = CALCULATE(SUM([Sales EUR]),ALLEXCEPT('Table','Table'[Year],'Table'[category]))/CALCULATE(SUM([Sales EUR]),ALLEXCEPT('Table','Table'[Year]))then change the visualization's setting.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. - fsfs
Helper I
I'll try to rephrase it
I have it like this:
*cat A *cat B
_______
| |
| 55%|
|______|
| |
| 45%|
|______|
I want it like this
_______
| cat A|
| 55%|
|______|
| cat B|
| 45%|
|______|
or like this
_______
| |
| 55%| --- cat A
|______|
| |
| 45%| --- cat B
|______|
- v-yalanwu-msft
Community Support
Hi, fsfs ;
You could add custom power bi visual as follows:
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. - v-yalanwu-msft
Community Support
Hi, fsfs ;
Is the above answer helpful to you? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.