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
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.