Forum Discussion
How to fix a button whose selection for 'yes' disappears because of another box?
IN DIRECT QUERY MODE
I created two visuals for:
This filters to last 30days if you click yes:
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.
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
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 ) )
1 Reply
- amitchandak
Super User
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
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 ) )