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.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
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.