Filter Multiple Table Columns and Metrics by date with One Slicer

[stharani]

Hi,

I have created a summary dashboard using multiple columns from different table. Now I have to add a slicer to that page so that I can filter all columns by Year, Month, or by Quarter.

How can I make one slicer to filter all the columns from different table?

[v-yiruan-msft · Accepted solution]

Hi @stharani ,

Please review the following links and check whether they are what you want. Hope they can help you.

1. Create a hierarchy slicer

Add multiple fields to a hierarchy slicer

Power bi slicer multiple columns with examples

2. Union multiple columns as slicer options

Creating a slicer that filters multiple columns in Power BI

Slicer =
DISTINCT (
    UNION (
        SELECTCOLUMNS (
            Customer,
            "Selection", Customer[State],
            "StateCountry", Customer[StateCountry]
        ),
        SELECTCOLUMNS (
            Customer,
            "Selection", Customer[CountryRegion],
            "StateCountry", Customer[StateCountry]
        ),
        SELECTCOLUMNS (
            Customer,
            "Selection", Customer[Continent],
            "StateCountry", Customer[StateCountry]
        )
    )
)

Best Regards