Forum Discussion
Hiding row labels from a table
How can we hide row lables from a table and still have the values showing?
Thanks
Vikash
Hi Anonymous ,
Based on my test, if you want to hide row labels from a table, you could set the Font color same with the Background color in column headers formating.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Anonymous , Use isfiltered or hasonevalue and force different formula
if(isfiltered(Table[Category]) ,[Measure with row filter] , [Measure without filter])
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Anonymous Well, you could turn off word wrap for headers and values and then grab the column divider with your mouse and drag it all the way to the left. ?
Or, maybe set conditional formatting for those values to be white on white?
Anonymous - Please check the Ideas forum and if it is not there, post it, I'll vote for it! @ me in any reply!
Hi Anonymous ,
Based on my test, if you want to hide row labels from a table, you could set the Font color same with the Background color in column headers formating.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Another way to do this:
1. "Rename for this Visual" on the row to "." (period)
2. Turn off Text Wrap for Row Header
3. Drag the column sizer to the left so you can't see the period (#1)
