Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
You could use RANKX Function to create a calculated table and then create a relationship.
You could use RANKX Function to create a calculated table and then create a relationship.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |