Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Gijs
Advocate II
Advocate II

Hide columns in table

Hi all,

 

I have a table with an X amount of columns, but not all information is relevant for everyone looking into the dashboard. I was wondering wheter it is possible to hide columns in a table as a user when you do not want to see those? And of course, the users should be able to unhide them as well if they would like to.

 

Best regards,

Gijs

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

hi, @Gijs 

There is no way to hide the column for now,

I suggest you could vote the ideas below which has been submitted in Power BI ideas forum and add your comments there to improve Power BI and make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/30945430-hide-show-column-on-tabl...

but as a workaround, you can hide the value in the columns with DAX, you can set measure value to blank based on selected options.

For example:

USERNAME Function

https://docs.microsoft.com/en-us/dax/username-function-dax

Measure = IF(USERNAME()=XXXX,BLANK(), CALCULATE(SUM(Table1[Value])))
BeforeBeforeAfterAfter
 

Best Regards,

Lin

Community Support Team _ Lin
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

4 REPLIES 4
lbendlin
Super User
Super User

This is now possible by enabling/allowing users to personalize visuals. That means they can add or remove columns as they see fit, without any developer involvement. Users can bookmark their choices for re-use.

DSmith4
Helper II
Helper II

A work around I did for this is turn word wrap off and make the column very small in width

v-lili6-msft
Community Support
Community Support

hi, @Gijs 

There is no way to hide the column for now,

I suggest you could vote the ideas below which has been submitted in Power BI ideas forum and add your comments there to improve Power BI and make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/30945430-hide-show-column-on-tabl...

but as a workaround, you can hide the value in the columns with DAX, you can set measure value to blank based on selected options.

For example:

USERNAME Function

https://docs.microsoft.com/en-us/dax/username-function-dax

Measure = IF(USERNAME()=XXXX,BLANK(), CALCULATE(SUM(Table1[Value])))
BeforeBeforeAfterAfter
 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I voted up the idea.

 

The username function will not work in my case since I would like the users themselves to be able to hide columns. So I guess the only thing I can do than is waiting until something like that would be implemented.


Regards,

Gijs

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.