Dynamic subtotal labels in Matrix chart

[prakash11440278]

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, Is there any other way to acheive the same functionality like matrix chart. Please help.

[v-henryk-mstf]

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]

Hi @v-henryk-mstf , Thanks for your reply. 

I am facing issue in matrix chart subtotals, not column chart. 

[amitchandak]

@prakash11440278 ,  I doubt there is an option as of now. Only static Label

You can log an Idea https://ideas.powerbi.com/ideas/

[prakash11440278]

@amitchandak ,Thanks for your reply.

Is there any workaround for this issue or any custom visual availble to fulfill this req. Pls advice.