slicer with yearly changing

[henry24007]

2021 Department

A

B

C

Change to

2022 Department

A

B

C1

I have a problem with changing the department name. In 2021 one of the departments changed its name from C to C1 but they are both the same. I would like to make a slicer that knows department C1 equals C and I made a column that looks like below:

Dept = IF([Department] = "C1", "C/C1", [Department])

But when I select 2021 in the year slicer, the report page will go blank with department C1 in the department slicer. It can only show 2022's data. What I want to do is to connect both C1 and C. when I select 2021 but use department C1 in the slicer, it can also display 2021'data and vice versa. It is possible to do that? I know that if I make C1=C by changing the column like IF([Department] = "C1", "C", [Department]) will work, but I want to keep the string "C/C1" that way.

[mangaus1111]

Hi @henry24007 ,

you can use the filter pane, instead of a slicer.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[henry24007]

sorry, but 3 or 3.1 is just a code for you to understand easier, actually, it could be department ABC