Multiple Filters

[daniellemarques]

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!

[daniellemarques]

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?

[v-jingzhang]

Hi @daniellemarques 

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.

[amitchandak]

@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