Forum Discussion

Abhijsrwala1's avatar
Abhijsrwala1
Frequent Visitor
4 years ago
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...
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    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.

Abhijsrwala1's avatar
Abhijsrwala1
Frequent Visitor
4 years ago

amitchandak I understand, but once those values are calculated how to bring that under one slicer along with rest of the values. As you can see. 01-Jan and calculated values are together in one slicer.