Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 as a user when you do not want to see those? And of course, the users should be able to unhide them as well if they would like to.
Best regards,
Gijs
Solved! Go to Solution.
hi, @Gijs
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.
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
Best Regards,
Lin
This is now possible by enabling/allowing users to personalize visuals. That means they can add or remove columns as they see fit, without any developer involvement. Users can bookmark their choices for re-use.
A work around I did for this is turn word wrap off and make the column very small in width
hi, @Gijs
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.
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
Best Regards,
Lin
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |