Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Folks,
Is there any idea in power bi show/hide column based on some criteria.
In SSRS it is possible using Column Visibility functinality which allows to hide or show column dynamically based on parameter value.
Regards,
Prateek Mangal
The solution we use is to create 2 tables, one with the column(s) and one without.
Then create a Bookmark for each state, ie one shows the table with all the columns and hides the limited table, then reverse for the other bookmark.
Place the two tables on top of each other and use a slicer / button etc to switch between the bookmark views.
To ensure filters are retained when changing between bookmarks, right click both bookmarks and deselect data.
Show/hide is currently static and universal. You cannot apply criteria.
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |