Filter Multiple Table Columns and Metrics by date with One Slicer

Question

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?

anonymous · Accepted Answer

Hi&nbsp;stharani&nbsp;,
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
&nbsp;
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]
        )
    )
)
&nbsp;
Best Regards

Forum Discussion

Filter Multiple Table Columns and Metrics by date with One Slicer

1 Reply

Related content

How to show multiple metrics/measures in a visual?

Sequential Order column based on multiple criteria

Multiple line and clustered columns chart

Fabric Capacity Metrics

Usage Metric report Refresh Issue