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...
Need Help
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?