Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Desired view :-
Values :- Sum of (Marks)
legend :- Category (A,B)
Axis :- Area Name
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,
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,
I use my data set and just create a stack bar: