Forum Discussion
Solved
Advanced Filter
How do I create a filter that has Jan,feb as well as This month, last fiscal year, as its elementn. Note : This month, last fiscal year are not in dataset, has to be calculated and included as slice...
Hi Abhijsrwala1 ,
The option in slicer must be the value in the column, so you should create a new table.
Slicer table = UNION ( VALUES ( 'Table'[Month] ), ROW ( "Month", "This month" ), ROW ( "Month", "Last fiscal year" ) )Get the result.
I attach my sample below for 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.
Hi Abhijsrwala1 ,
The option in slicer must be the value in the column, so you should create a new table.
Slicer table =
UNION (
VALUES ( 'Table'[Month] ),
ROW ( "Month", "This month" ),
ROW ( "Month", "Last fiscal year" )
)
Get the result.
I attach my sample below for 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.