Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Hide columns in table

Hi all,   I have a table with an X amount of columns, but not all information is relevant for everyone looking into the dashboard. I was wondering wheter it is possible to hide columns in a table a...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, Anonymous 

There is no way to hide the column for now,

I suggest you could vote the ideas below which has been submitted in Power BI ideas forum and add your comments there to improve Power BI and make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/30945430-hide-show-column-on-table

but as a workaround, you can hide the value in the columns with DAX, you can set measure value to blank based on selected options.

For example:

USERNAME Function

https://docs.microsoft.com/en-us/dax/username-function-dax

Measure = IF(USERNAME()=XXXX,BLANK(), CALCULATE(SUM(Table1[Value])))
BeforeAfter
 

Best Regards,

Lin

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I voted up the idea.

     

    The username function will not work in my case since I would like the users themselves to be able to hide columns. So I guess the only thing I can do than is waiting until something like that would be implemented.


    Regards,

    Gijs