Forum Discussion

fsfs's avatar
fsfs
Icon for Helper I rankHelper I
5 years ago
Solved

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?    
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    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's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
5 years ago

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.