Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello!
I'm new to Power BI and am still learning the basics. Currently, I'm facing an issue related to table visibility based on slicer selections. I've used the measure:
SlicerSelection = SELECTEDVALUE('Activity'[Activity1], "None")
I then set this measure as a filter for the table. It works as expected: when I select an option from the slicer, the corresponding table displays. However, when I choose a different option in the slicer, the headers from the previously displayed table remain visible. Is there a way to hide these headers when a relevant table option isn't selected?
Try using field parameters. For a detailed explanation check this documentation.
Proud to be a Super User!
Thank you! However, I have another concern. I want to display an entire table that has around 15 columns. Is it possible to set just the table name as a parameter, rather than specifying individual columns?
Not to my knowledge. Field parameters only work with columns.
Proud to be a Super User!
Thank you for the reply!
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |