Forum Discussion
Column chart display only specific records
Hello, I am tracking some donation data and found some measures to give me the data I want to see in a Matrix visual, but I can't figure out how to display specific records in a column chart. To exp...
Hello, you will need a measure to achieve this. Heres the DAX but you will need to massage it to your table name, field name etc:
% of Group =DIVIDE(SUM(Donation[Val]),CALCULATE(SUM(Donation[Val]),ALL(Donation[Group])),0)
Thank you, that was very helpful, but how do I show the data labels as %? Is there a format within the Measure that should be added?
I found it! In the Measure Tools. All good now. Thanks again!