Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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 .

Need Help

17 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    10 years ago

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

    • S184019's avatar
      S184019
      Icon for Advocate III rankAdvocate III
      7 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      How can i do this ?

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        10 years ago

        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. 

    • yamenmarquez's avatar
      yamenmarquez
      Frequent Visitor
      8 years ago

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

       

      Thanks in advance

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

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

         

  • ankitpatira's avatar
    ankitpatira
    Icon for Community Champion rankCommunity Champion
    10 years ago

    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's avatar
      Anonymous
      Not applicable
      10 years ago

      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 :                    

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

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

  • rangerman's avatar
    rangerman
    New Member
    4 years ago

    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. 

  • Stephcurry30's avatar
    Stephcurry30
    Regular Visitor
    2 years ago

    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.

     

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

    4.Then Resize the width of the column

     

     

    Thanks & Regards
    Manu<30>

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.