Forum Discussion
Post ProdigyBetween slicer showing more dates than data
Hi Justas4478 ,
I make a mistacke, change the MIN where I framed with red lines to MAX.
Get the correct result:
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi Justas4478 ,
According to your description, here's my solution.
Create a measure:
Measure =
VAR _min =
MIN (
MIN (
MINX ( ALL ( 'co agency' ), 'co agency'[Date] ),
MINX ( ALL ( 'pr agency' ), 'pr agency'[Date] )
),
MINX ( ALL ( 'sp agency' ), 'sp agency'[Date] )
)
VAR _max =
MAX (
MIN (
MAXX ( ALL ( 'co agency' ), 'co agency'[Date] ),
MAXX ( ALL ( 'pr agency' ), 'pr agency'[Date] )
),
MAXX ( ALL ( 'sp agency' ), 'sp agency'[Date] )
)
RETURN
IF ( MAX ( 'Calendar'[DATE] ) >= _min && MAX ( 'Calendar'[DATE] ) <= _max, 1 )
Put the measure in the slicer visual filter and select show items when the value is 1. Get the correct result:
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Justas4478v-yanjiang-msft Hi, your solution partially works. It filters data as I expect but the data displayed on the calendar is wrong even tho data is filtered correctly. Data is up to 28/07/23 but the calendar i showing till 15/07/23 even tho it filters till 28/07/23 which is missleading. I dont know what is causing this interaction.
- v-yanjiang-msft
Hi Justas4478 ,
I make a mistacke, change the MIN where I framed with red lines to MAX.
Get the correct result:
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.