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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

Yes, but I want to see only current and last year (2018 & 2019), do not show the future year (2020)

 

How to do that?

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago
Please provide some sample test data that can be copied to suggest an accurate solution.