Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have a report and I want a fixed filter for every data of this report to show me the data of today's date. But I also want to add filters in this same report and change it to other dates. Is this possible or I have to create another report to do it?
Thanks in advance!
Actually,
I want to my dash when has no filters, give me the today's month date results, and when I filter on calendar it changes to the date I choose , or even sum 2 months results. Can you help me?
You can refer to this blog: Power BI Tutorial: Dynamically update Date slicer to show Current Date – business intelligist
Currently Power BI will keep the selected value in a slicer. It means when you log out of Power BI and come back to a report, the same items will be selected as when you left. It cannot be updated automatically. So in above blog, it selects a fixed Most Recent Date value in the slicer. Every time the data is refreshed, the Most Recent Date value will be updated.
In your scenario, you can add a calculated column like SlicerDate = IF ( 'Table'[Date] = TODAY(), "Today", 'Table'[Date] & "" ) and use this column in the date slicer. When you refresh the data, the calculated column will be updated.
Kindly let me know if this helps.
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
@daniellemarques , You can create a flag like this in date table
Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"")
Sort this one date and use it as slicer and default of Today. : https://www.youtube.com/watch?v=KK1zu4MBb-c
Also, you can control the interaction to have different filters
refer: https://www.youtube.com/watch?v=GIfRKzhMaR4
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |