Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
How can we hide row lables from a table and still have the values showing?
Thanks
Vikash
Solved! Go to Solution.
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)
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.
@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?
Thanks Greg,
Whilst this would work in Tableau you have a siple option of hiding row or column headers, which makes formatting a lot easier. I guess this needs toi be added as a feature in Power BI
Thanks
Vikash
@Anonymous - Please check the Ideas forum and if it is not there, post it, I'll vote for it! @ me in any reply!
@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/
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |