Default Date and Full Date visual based on previous month date

[Priya1969]

My visual has values from January 2020 to December 2023. My requirement is when I open the report want to see the previous month and greater than previous month results. Also, I need the option to see "Full" values from Jan 2020 to December 2023.

I created this Dax query for filter the values, (// Append1 is table name)

 Date view = IF(Append1[DATE] >= Append1[Previous_Month].[Date], "Default", IF(Append1[DATE] <= Append1[Previous_Month2].[Date], "Full"))

// Previous Month Dax is 

Previous_Month = EOMONTH(NOW(),-2)+1

1. My 1st option is fulfilled. It shows the results from Previous month to end of December 2023.

2. When I select the Full option it shows up tp 10/1/222 from January 2020. Beacuse I gave <= previous month.

But, when I select "Full", I want to show upto December 2023. I don't know how to fulfill. Tried multiple ways, missing somewhere. What extra query I need to add here? Can someone help me solve this?

Thanks!

[v-zhangti · Accepted solution]

Hi, @Priya1969 

You can try the following methods.

Measure = IF(SELECTEDVALUE('Table'[Date])<=[Previous_Month],1,0)

This is the default date.

The full date is displayed when this measure is cleared.

Hope this method helps you.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Priya1969]

Hi, Thanks for the reply. It's almost correct. Instead of giving measures in 'fiters on this visual' option, I did something like this. 

Date View = IF(Append1[DATE] >= Append1[Previous_Month].[Date] ,"Default","Other_Dates")

Then, in the format, slicer selection, on the 'Select all" option. Then it will show like this.

If i select, 'Select all' option, it shows all the dates.