Forum Discussion
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
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
- amitchandakSuper User
Lovebo01 , white color is the only option. On top of that put some image or text box
- parry2kSuper 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.⚡
- AnonymousNot 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.