Forum Discussion

prakash11440278's avatar
prakash11440278
Post Prodigy
4 years ago

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

Need Help

4 Replies

    • prakash11440278's avatar
      prakash11440278
      Post Prodigy
      4 years ago

      amitchandak ,Thanks for your reply.

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

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    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.