How to fix a button whose selection for 'yes' disappears because of another box?

[Anonymous]

IN DIRECT QUERY MODE

I created two visuals for:

Is it Today = if(DATE(YEAR('SPROC Snapshot'[ONP Date]), MONTH('SPROC Snapshot'[ONP Date]), DAY('SPROC Snapshot'[ONP Date])) = Today(), "Yes", "No")

and

Is it Last 30days = if(DATE(YEAR('SPROC Snapshot'[ONP Date]), MONTH('SPROC Snapshot'[ONP Date]), DAY('SPROC Snapshot'[ONP Date])) >= Today()-30, "Yes", "No")

This filters all the data to the current date if I select yes.

This filters to last 30days if you click yes:

But for some reason if the button Last 30 days is clicked no,

The is it today box only shows the selection for No (Yes dissapears)????

If i click Last 30days? Yes, then the button for Is It today? Yes appears.

I'm not sure why this occurs, any help would be appreciated.

@amitchandak @Anonymous @Greg_Deckler

[amitchandak · Accepted solution]

@Anonymous , Last 30 Days include today, so when you make it no you will not get yes for last 30 days.

Check if TI based on today can help

https://medium.com/chandakamit/cheat-sheet-power-bi-time-intelligence-formulas-using-today-654f26e27304

You can create field parameter or calculation group

Today = CALCULATE([Net], FILTER('Date','Date'[Date] = Today() ) )

Last 30 Days= CALCULATE([Net], FILTER('Date','Date'[Date] <= Today() && 'Date'[Date] >= Today() -30 ) )

https://medium.com/chandakamit/cheat-sheet-power-bi-time-intelligence-formulas-using-today-654f26e27304