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.
We are trying to create Dynamic Slicers based on field parameters, and trying to populate them in a slicer. Based on the slicer selection we are showing the values of the columns in a table. On "Select ALL" the order of the column remains intact in the table, but on resetting the slicer and upon selecting individual slicer values(multiple selections) the sequence of the columns in the table
is not maintained and the column selected from the slicers gets appended in the table as per the order in which they are selected in the slicers. We want the order of the columns in the table must be maintained as per the order we have in the Field parameter order. Please suggest if there any solutions to this.
Solved! Go to Solution.
Hi @Aparimita
I can offer one suggestion (PBIX attached)
Doing it this way, the order in which the filtered fields are displayed in the visual will always follow the Order column in the field parameter table, and not the order of selection.
It appears that the order of selection is followed only when the filter is applied directly on the field parameter table.
In attached PBIX, the order of the "Column Selection" fields is always Country-Region, Category, Color.
Regards
Thanks, @OwenAuger , Your solution worked, thanks a lot for your swift response
Hi @Aparimita
I can offer one suggestion (PBIX attached)
Doing it this way, the order in which the filtered fields are displayed in the visual will always follow the Order column in the field parameter table, and not the order of selection.
It appears that the order of selection is followed only when the filter is applied directly on the field parameter table.
In attached PBIX, the order of the "Column Selection" fields is always Country-Region, Category, Color.
Regards
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 |
---|---|
96 | |
94 | |
82 | |
70 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |