Forum Discussion

stharani's avatar
stharani
Regular Visitor
4 years ago
Solved

Filter Multiple Table Columns and Metrics by date with One Slicer

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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