Forum Discussion

ujeyakum's avatar
ujeyakum
Regular Visitor
8 years ago

How to Hide a Column in power Bi

Hi All,   Can you please help me how to hide "Column A" in table but that column should be in order.   For example.   [ Spoiler ]   Thanks, Jeyakumar.
MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi ujeyakum,

 

On PBI if you rigth click the column name or table you can select the option Hide, this will hide the column from the visualization however you are abble to use it in your measures and calculations and is visible on the tables view in a grey format.

 

Regards,

MFelix

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi ujeyakum,

 

You could adjust the column width manually. 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 you could adjust the width of this column.

 

For the better visualization, you 'd better turn off the Word wrap in the format pane. The below should be your expected output.

 

Hope it can help you!

 

Best Regards,

Cherry

  • ujeyakum's avatar
    ujeyakum
    Regular Visitor
    8 years ago

    Hi Cherry,

     

    Thanks for your reply.

     

    I did the same but when you export the report it showing the column. How can i avoid that also.

     

    Can you pls help me on this.

     

     

    Thanks ,

    Jeyakumar.

      • bajee's avatar
        bajee
        Icon for Kudo Kingpin rankKudo Kingpin
        8 years ago

         

         

         

        If you right click on column you will get options as screenshot.

         

        select the hide option that particular column will be hide.If you want you can unhide the column

         

        Regards,

        Bajee.