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 all,
I'm using the field parameter preview function in one of my reports to select columns for a table. However, I would like the default of the slicer to be 'select none' if none of the fields is selected. By default it is 'select all'.
This might not be specific to field parameter slicers, but to slicers in general. Is there a way to achieve this?
Thanks!
Solved! Go to Solution.
What you can do with the new feature of Field Parameters (check in Preview features):
What you can do with the new feature of Field Parameters (check in Preview features):
Hi @EdwardMoradian Thank you for your reply on this.
Are there any other ways to handle this None column (hiding from table visual) because users point of view it is not ok to show them in the visual level.
Instead of a blank column, or a measure with an empty value, use this hack courtesy of Barney Lawrence . Add a row to your table like this.
Percentiles = {
("None", "Any non-empty string", 0),
("Network P0", NAMEOF('Table'[Measure]), 1)
}
The column will not show up at all whether it is selected, or all are selected.
@Anonymous , use a visual level filter
measure = int(isfiltered('field parameter'))
check above measure =1 in visual level filter
This will hide all rows
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 |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
98 | |
81 | |
72 |