cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vijayashanti
Microsoft
Microsoft

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 .

3 REPLIES 3
ankitpatira
Community Champion
Community Champion

@vijayashanti In power bi desktop you can right-click your column / columns and click Hide and that will hide it from the report. When that report is published to power bi service you won't see that field and also when you export as csv from the visual you won't get that field. 

Thank you @ankitpatira ,

 

Our requirement is like, we should get that hidden field in CSV file.

Hi @vijayashanti,

 

Currently, there is no such a functionally to allow us hiding column in a table visual. As ankitpatira said, if you hide it in source table, then the column is unavailable when exporting to CSV.  So currently, I am afraid your requirement cannot be done.

 

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

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors