Year and location name on the same slicer?

[Anonymous]

I have a report, with a requirement to show a 'radio button' filter with columns from 2 different dimensiones...

It should look like this:

2021

2022

2023

2024

Location 1

Location 2

Location 3

So, I have a slicer that shall have both Year from Time dimension and Name from Location dimension...

How can I achieve this? (I have suggested to have 2 different slicers, but unfortunately I must do it in only one slicer...) 

ps: is it doable? what are my options? I am even willling to create new tables to achieve it.

[Anonymous]

it only seems to work if I also add either Table'[Year]) or ('Table'[Location])  to the table... If none of them appear it doesnt work...

I dont want to include them in the table visual

[v-easonf-msft]

Hi, @Anonymous 

Currently, it is difficult to create such a radio button using fields from two different dimension tables. Integrating data is the most straightforward approach.
For your last question, I suggest you recheck my attachment.

The data in the table visual is filtered normally even if the year and location are not added to the table.

Best Regards,
Community Support Team _ Eason

[Anonymous]

you have year and location in the same table, as I mentioned in my case they are in the dimensions...

[v-easonf-msft]

Hi, @Anonymous 

Please try following steps:

1.Add a calculated table

Table 2 = UNION(VALUES('Table'[Year]),VALUES('Table'[Location]))

2. Rename Table2[Year] to Table2[Value] and add it to the slicer

3. Create custom measure 'filter' and apply it to each visual filter pane

filter = 
VAR a =
    IF (
        MAX ( 'Table'[Location] )
            IN VALUES ( 'Table 2'[Value] )
                || FORMAT ( MAX ( 'Table'[Year] ), "General Number" )
                    IN VALUES ( 'Table 2'[Value] ),
        1,
        0
    )
RETURN
    IF ( ISFILTERED ( 'Table 2'[Value] ), a, 1 )

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