How to show Total value and %percent value both together in Line and clustered chart like screenshot

[aamirkhan_WT]

Hi All

How to show Total value and %percent value both together in Line and clustered chart like screenshot below
How to create this if you can the file or steps it will be helpful

[aamirkhan_WT]

Is there anyone who help on this. Or if you cannot let me know as you cannot do

[aamirkhan_WT]

Anyone who can help on the above ask

[danextian]

Hi @aamirkhan_WT 

Please look into using custom data labels - https://goodly.co.in/custom-data-labels-power-bi/ 

[aamirkhan_WT]

This is not what I want . if you see the the screenshot 
Legend value remain as it is only I want Total metric will show with percentage

[danextian]

You need to write a custom data label for that or you can make use of the detail tile.

custom data label

default label + detail

please see sample pbix

[aamirkhan_WT]

But where is bars I can see only line no bar. I want bar only with number and in line it will total with percentage

[danextian]

You can just change the viz to cluster column and line chart and fiddle with either the custom data label or detail. Each measure/series will have its own option.

[aamirkhan_WT]

When I use legend as cotagory its not wrong

[danextian]

It appears to be a bug. Custom data label or detail label doesn't work when a category is used as column legend.

[aamirkhan_WT]

It means your saying bug or its not possible ?