Forum Discussion
prakash11440278
4 years agoPost Prodigy
Dynamic subtotal labels in Matrix chart
Hi All, Is it possible to change the subtotal labels as dynamic. Currently there is no option to change subtotal labels to dynamic based on the values. I know this not possible using matrix chart, I...
v-henryk-mstf
4 years agoCommunity Support
Hi prakash11440278 ,
Based on your description, try to use slicer as a way to achieve a similar effect by using dynamic filter tags. For reference, I have done the following tests:
Measure =
var a = SELECTEDVALUE(Slicer_[ID])
return
IF(MAX('Table'[ID])=a,MAX('Table'[Value]),BLANK())
If the problem is still not resolved, are you able to further describe your needs or provide desired expected results. To facilitate me to answer you as soon as possible.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
prakash11440278
4 years agoPost Prodigy
Hi v-henryk-mstf , Thanks for your reply.
I am facing issue in matrix chart subtotals, not column chart.