Dynamic Slicer Selection

[mjmar025]

Is it possible to have the selection of a slicer change dynamically to only have the top 2 values selected (for a dimension that is constantly changing)? This is different than a visual level filter because I would not like to remove the other values from being available to select - I just have a specific starting point that I'd like the user to open the dashboard to. This would prevent me from having to go into the dashboard on a daily basis and manually change the selections before re-uploading the file to our report server.

[v-chuncz-msft · Accepted solution]

@mjmar025,

You could use RANKX Function to create a calculated table and then create a relationship.