Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Hide some values in Slicer

Hi Experts,   I need a help, I have Actuals and Plan data.   In the actuals i have 2018 and 2019 data only, but in the plan i have 2018, 2019 and 2020. I have appended the actuals and plan into o...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    Create a year table

    year table = SELECTCOLUMNS(GENERATESERIES(2018,2019,1),"year",[Value])

    Create relationship as below

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous Please try using the date field in the Visual level filter (In this case, it is slicer) and then use "Relative Date Filtering" to last 2 years either Years or Calendar Years based on your requirement. 

 

Note - In your slicer you will be using the "Year" value only (from the date hierarchy)

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Manohar,

     

    I do not have date field in my data.

     

    Please some example, so that i can work out and try.

     

    Regards,

    Swamy