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

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
Icon for Community Champion rankCommunity 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"

     

                        

     

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

      Yes, Export Data, sorry. I added a custom column and a custom measure with DAX calculations in them and I see both columns in my table when I check the data.csv file that is exported.