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
Anonymous
Not applicable

How can i hide Column/measure in a Table

Hi All,

 

Can we hide a column / measure in a Table .

Basically, I want to show only first 5 column on report , but when the user Export .csv , all the hidden column/measure should also be visible.

 

Thanks .

17 REPLIES 17
Stephcurry30
Regular Visitor

HI @Anonymous, you can hide a column in a table visual using the following steps:

1.Create your table visual.

2.In the visualizations pane, navigate to the 'Format' options.

Stephcurry30_0-1706858041497.png

 

3.Under 'Values' and 'Column Headers' uncheck 'Text Wrap.'

Stephcurry30_1-1706858275870.png

4.Then Resize the width of the column

Stephcurry30_2-1706858360374.png

 

 

Thanks & Regards
Manu<30>

Anonymous
Not applicable

hi,

the best option in my opinion is to put the column last. Then in the formatting, adjust specific column text color and background to white. You still get lines for that column but I did not find any cleaner option to achieve it.

rangerman
New Member

I know this post is old but since it doesn't look like an answer was provided, you can add whatever field you want to appear in the CSV export in the drill-through data of your visual. This data won't show on the visual but will appear on the export and of course the drill through pane. 

v-caliao-msft
Microsoft Employee
Microsoft Employee

Hi Mridul,

 

According to your description, you need to hide columns on your report, and the hidden columns should visible after export the report to CSV file, right?

 

Based on my research, there is no a visibility option for the columns in current version of Power BI report. So I am afraid your requiremnet cannot be achieved currently.

 

If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Regards,

Charlie Liao

ankitpatira
Community Champion
Community Champion

@Anonymous In PBI desktop, you can first build all your visuals using required columns in your table. Then go to Data tab, select your table and column, right click & Hide in report view. This will make column disappear from the column list in report view, but all your visuals will stay as it is. When exporting to csv data will be there as well.

Anonymous
Not applicable

The problem is that my column is composed by a measure. There is any other way to do that?

Anonymous
Not applicable

@ankitpatira : As per your solution i can hide from the Fields column on right but still see the hidden column on Report in Table Visualization, but i think the workaround is just by dragging the column on left side as smoupre has explained. 

 

Is there a way to export your Measure in csv /Excel ?

 

Thanks :                    

 

Greg_Deckler
Super User
Super User

You can shrink the column down to the point that it is not visible but not truly hide it.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Is there an idea that is slated to be published to fix this blatent gap? 

When I do this the height of the rows increases. How can I hide the column without this happening?

 

Thanks in advance

Anonymous
Not applicable

@yamenmarquez I renamed the column to a dot "."   Then I turned Values->WordWrap to OFF. 

 

Anonymous
Not applicable

How can i do this ?

@Anonymous - In your table visualization, hover your mouse over your column heading that you want to "hide" and move it to the right until the mouse cursor changes to a <->, then left-click and drag to the left until it is completely hidden. 


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@Greg_Deckler Thanks for the workaround. Is there a way to export my measure calculation in CSV. 

                   All i am trying to do is to build some measures on the Hidden column , and export csv with the measure. 

                   

 

@Anonymous - If you click the ellipses on the table visualization and click "Export to Excel" then it will export everything in the table, even the "hidden" columns. Is that what you are asking?


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@Greg_Deckler :  I can see the hidden column in my .csv Export data , I hide columns using <-> icon on Table.

                      BUT, i also used some DAX formulae in Hidden column, which i DID NOT see in .csv exported.

                      Also, i used all the columns on Tables , which is used in DAX formulae.

 

                      Secondly, I see "Export Data" Option on my Table Exclipse(...). I dont see the Option called "Export to Excel"

 

Export_Data.png

                    

 

Yes, Export Data, sorry. I added a custom column and a custom measure with DAX calculations in them and I see both columns in my table when I check the data.csv file that is exported. 


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
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.