Forum Discussion

Lovebo01's avatar
Lovebo01
Helper I
6 years ago
Solved

Format Matrix show row headers with only one value

Hi everyone,

 

I am trying to show row headers in a matrix with only one value and the Format option -> Values -> 'Show on rows'

 

If you have 2 values : 

 

 

But If you have only one value, the row header disappear :/, I would like to show "Quantity" value on the left :

 

 

 

In the same time I am trying also to hide the column headers, the only way I found it's to use a shape or font and background = white. Is there a better way ?

 

Thank you everyone,

Take care,

Lovebo

  • parry2k's avatar
    parry2k
    6 years ago

    Lovebo01 if it is a single measure, it will not show value on rows, you can add a title rather showing Quantity on rows, no way to hide title except changing the color or some other hack.

     

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

3 Replies

    • parry2k's avatar
      parry2k
      Super User

      Lovebo01 if it is a single measure, it will not show value on rows, you can add a title rather showing Quantity on rows, no way to hide title except changing the color or some other hack.

       

      I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

      Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

  • Anonymous's avatar
    Anonymous
    Not applicable

    You can add another row of the same value to have two rows with their header, then cover the 2nd row with a white/background box or another visual if you have one.