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 using Slicer in Power BI Desktop. The data source for the slicer is a list of existing builds, which is updated from time to time.
The user want the slicer to always select latest 3 builds as default.
Is there any way we can accomplish this?
Thanks,
Di
Solved! Go to Solution.
Hi,
According to your description, i think you can not set default select for slicer, but i have a workaround.
Here is my test sample in SQL Server:
Then add an index column in Query Editor.
After Apply&Close, add this index as a filter to the table visual, it shows:
When i add data in SQL Server:
Click Refresh function in Power BI Destop, it shows the latest three rows:
If you want to filter other data, you can still use slicer after removing this Index filter.
Hope this helps.
Best Regards,
Giotto Zhi
Hi,
According to your description, i think you can not set default select for slicer, but i have a workaround.
Here is my test sample in SQL Server:
Then add an index column in Query Editor.
After Apply&Close, add this index as a filter to the table visual, it shows:
When i add data in SQL Server:
Click Refresh function in Power BI Destop, it shows the latest three rows:
If you want to filter other data, you can still use slicer after removing this Index filter.
Hope this helps.
Best Regards,
Giotto Zhi
Well, perhaps create a Top N filter by Date or maybe create a column that does a RANKX by Date and then just filter to 1,2,3
I am not sure if I get you correctly, are you saying to show top 3 only? We still need to show the whole list of builds for user to select.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |