Forum Discussion

Dan849800's avatar
Dan849800
Frequent Visitor
9 years ago

Date change based on month selection

I have year, Month,Date filters in Power BI, By default it shows all dates but when i select March , date slicer should show only march dates instead of all dates. I don;t want to hierarchy slicers.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Dan849800,

    Do you use the Month slicer to filter the Date slicer? If so, if you create the slicers using fields in same table, make sure that you select “Filter” instead of “None” in the Date slicer. There is an example for your reference.


    However, if you create slicers using fields in different table, besides  the above condition, you would need to establish relationship between the two tables.

    Thanks,
    Lydia Zhang