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

How can i do this ?

Greg_Deckler's avatar
Greg_Deckler
Community 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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    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. 

                       

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      10 years ago

      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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        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"