Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Hide Column header and set dynamic Total Text

Hi @All,

 

I have two questions about matrix.

-How to hide column header in a Matrxi?

-Is that possible to set dynamic name of Total ? In my scenario, The total should be Q1 and when another Quarter is selected in slicer, the text of total should be Q2. Any solution or work around?

 

 

 

Regards,

Frank

 

Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi Anonymous ，

     

    Based on my test,to hide column header in a Matrxi is not available currently.

    But there is a workaround you may refer to:

    First create a slicer table with all the values you wanna show in total;

    Then create a measure as below:

    Measure = SELECTEDVALUE('Slicer table'[Slicer])

    Put the measure in a card visual and you will see:

     

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous 

     

    Both of these ask are not possible in matrix.

     

    Did I resolve your issue? Mark my post as a solution!

     

    Appreciate your Kudos, Press the thumbs up button!!

     

    Regards,
    Pranit

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi Anonymous ，

     

    Based on my test,to hide column header in a Matrxi is not available currently.

    But there is a workaround you may refer to:

    First create a slicer table with all the values you wanna show in total;

    Then create a measure as below:

    Measure = SELECTEDVALUE('Slicer table'[Slicer])

    Put the measure in a card visual and you will see:

     

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!