Forum Discussion
Dynamic Top N based on column ordering
To make the TOP N filter dynamic based on the column selected by the user, you can create a dynamic slicer using a What-If Parameter:
1. Create a slicer table that contains all the headers of the columns you want to filter into one column.
2. Create a measure that uses the RANKX function to rank the values based on the selected column.
3. Use the slicer to filter the values based on the selected column.
The TOP N filter will update dynamically based on the column chosen for ordering by the user.
Thank you for the quick response. Is there any way to make the TOP N update based on the column the user selects?
To make the TOP N filter dynamic based on the column selected by the user, you can create a dynamic slicer using a What-If Parameter:
1. Create a slicer table that contains all the headers of the columns you want to filter into one column.
2. Create a measure that uses the RANKX function to rank the values based on the selected column.
3. Use the slicer to filter the values based on the selected column.
The TOP N filter will update dynamically based on the column chosen for ordering by the user.