Hi everyone,
I've recently been creating a small multiple bar chart, however within each small multiple, I would like to be able to add a tooltip to show the bar value as a % of the small multiple total, rather than the grand total across all 4 of the below charts. I've added a dummy mock up below to demonstrate what my set up is similar to but for example, I'm looking to show what the value of the CAT A bar as a % of the total within the A small multiple, so it's equal to 10% in this instance.
Any thoughts would be much appreciated on how to calculate this measure please! Thanks
Hi, @Anonymous
Try to create a measure like this:
Measure =
DIVIDE(MAX('Table'[Value]),CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Attribute])))
Result:
Please refer to the attachment below for details. Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
Try to create a measure like this:
Measure =
DIVIDE(MAX('Table'[Value]),CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Attribute])))
Result:
Please refer to the attachment below for details. Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
