Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to create this visual with percentages as data labels ??

Desired view :-

Values :- Sum of (Marks) 

legend :- Category (A,B)

Axis :- Area Name

 

 

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I use my data set and just create a stack bar:

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    We can make a stack bar chart easily but we did not found an effective way to  put percent value of each category as data label. We can create a measure in Tooltips field as a workaround.

     

    Percent = DIVIDE(CALCULATE(SUM('Table'[Marks])),CALCULATE(SUM('Table'[Marks]),FILTER(ALL('Table'), [Aera] in FILTERs('Table'[Aera]))))

     

     


    Best regards,

     

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


    Best regards,