Forum Discussion
Helper IISlicer Dynamism based on Dim Date Slicer
Hi Vamshi2020 ,
You can create a visual level filter for Provider Id Slicer:
Measure = var a = MAX(Provider[Effective Date]) var b = MAX(Provider[Termination Date]) return IF(MIN('Dim Date'[Date])<=a&&MAX('Dim Date'[Date])>=b,1,0)And set it to 1:
For more details ,please refer to sample pbix: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EScQwbIyUEZMjtxReisFzzIB1lrmfaWT6jWyJILd1eq5Og?e=LQbL7y
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Community SupportHi Vamshi2020 ,
You can create a visual level filter for Provider Id Slicer:
Measure = var a = MAX(Provider[Effective Date]) var b = MAX(Provider[Termination Date]) return IF(MIN('Dim Date'[Date])<=a&&MAX('Dim Date'[Date])>=b,1,0)
And set it to 1:
For more details ,please refer to sample pbix: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EScQwbIyUEZMjtxReisFzzIB1lrmfaWT6jWyJILd1eq5Og?e=LQbL7y
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai