Forum Discussion
Solved
YTD Custom Slicer
Perhaps I'm missing something simple, or just can't quite get the search terms right. I have a report with a fiscal year and fiscal month slicer. When a fiscal month is selected, we would like to s...
Hi, gilmara ;
We need add another new table about Period.
Period = VALUES('Table'[FiscalPeriod])Then add a flag measure.
flag = IF(MAX('Table'[FiscalPeriod])<=MAX('Period'[FiscalPeriod]),1)Apply it into filter.
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, gilmara ;
We need add another new table about Period.
Period = VALUES('Table'[FiscalPeriod])Then add a flag measure.
flag =
IF(MAX('Table'[FiscalPeriod])<=MAX('Period'[FiscalPeriod]),1)Apply it into filter.
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.