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?

mussaenda's avatar
mussaenda
Community Champion
7 years ago

Before appending two tables, put additional column on each using M query. 

Actual table, add custom column,

Custom = "Actuals"

Plan Table, add custom column,

Custom  = "Plan"

Then append them like what you did.

 

on the page filter pane, drag the custom column and check only the actuals.