cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Hiding row labels from a table

How can we hide row lables from a table and still have the values showing?

 

Thanks

Vikash

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Hi @vikash_1108 ,

 

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.

2.png

 

 


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.

View solution in original post

5 REPLIES 5
Highlighted
Super User IV
Super User IV

@vikash_1108 , 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/



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Super User IV
Super User IV

@vikash_1108 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?


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted

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

Highlighted

@vikash_1108 - Please check the Ideas forum and if it is not there, post it, I'll vote for it! @ me in any reply!

https://aka.ms/PBI_Comm_Ideas


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Microsoft
Microsoft

Hi @vikash_1108 ,

 

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.

2.png

 

 


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.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors