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,
Share the download link of the PBI file. Also, from which month does your FY start?