Power BI

Needs Votes

Epic idea: Apply filter selections automatically

Vote (4624)

Miguel Myers on 08 Oct 2024 05:00:00

Imagine a world where report creators can automatically apply slicer and filter selections based on specific logic, revolutionizing data analysis and user experience. This innovative approach eliminates any need for complex workarounds, optimizes slicer functionality, and paves the way for more efficient and effective data reporting.

Comments (418)

Robert M Foose on 05 Jul 2020 22:49:54

RE: Epic idea: Apply filter selections automatically

I keep trying to make PowerBI work like SSRS rdl files.
I used to be able create a parameter with a dynamic value and then set report filters to that dynamic value as a default but still allow my end users to have the ability to explore previous months and years

I see that PowerBI thinks filtering the data by value is a solution...but I don't believe this will work as I'm intending.

Being able to not only set the default value of a slicer but also make that value dynamically, would be essential. Not nice. ESSENTIAL.

Mike Rottmann on 05 Jul 2020 22:49:53

RE: Epic idea: Apply filter selections automatically

The slicer should be able to set the default value. For example, I have a list of all companies and a slicer on the active (yes/no) column. It would be nice to default to Yes so that active companies appear and have the option to display all or non active companies

Muhammad Shahzad on 05 Jul 2020 22:49:50

RE: Epic idea: Apply filter selections automatically

Slicer should have ability to select Default date and value of the default date can be assigned any custom date or Today, yesterday or tomorrow or any combination, i have been working in Pentaho for 2 years now and they have a solid date range control, which is amazing, Slicer should have straight fwd options like:
1. Today
2. Yesterday
3. Last week
4. Current week
5. Last Month
6. Current Month
7. Last Year
8. Current Year
9.Year to date
10. Specific date
11. Date Between