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.
I would like to create a visual that allows the user to flexibly add or subtract columns.
For example, selecting "Area" and "City" in the slicer as shown below would add the "Area" and "City" items to the rows of the matrix visual:
As a second example, if you uncheck "City" in the slicer and select "Area", "Product", and "Type" as shown below, the three selected items will be displayed:
Is it possible to achieve these functionalities? If not, are there any alternative methods or ways to achieve these functionalities without using matrix visual or slicers (such as using custom visuals)?
Please let me know if there is any information available on using custom visuals or other methods to achieve these functionalities, even if it is not possible to achieve them perfectly.
Kind regards,
The only way I can think of is to deploy the report with only one item selected. That is how the report will default when the users open it.
Thank you for your answer!
Field parameters are a great solution. However, if nothing is selected, all items will be displayed. Is there a way to only display them when selected?
As there are quite a large number of items, we would like to minimize the initial display as much as possible.
You can accomplish this using a fields parameter.
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
It will allow the users to select the field to display and even what order to display them in (it switches base on the order they select them).
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |