un define

Hi @atul06 ,

Thanks for reaching out to the Microsoft fabric community forum.
Try these steps to solve the issue :

Set up a Proper Date Table

Use Power Query or DAX to create a Date table covering the full date range of your data.

Include columns for: Year, Quarter, Month, Date, etc.

Mark it as the Date Table in Power BI (Model view).

Enable Date Hierarchy

Power BI auto-generates hierarchy (Year - Quarter - Month - Day) when you include the Date field in visuals.

Alternatively, create a Field Parameter manually if you wish to control which levels appear in slicers.

Use Field Parameter 

Go to Modeling - New - Field Parameter - select the date hierarchy columns.

Use that new parameter for both your slicer and your matrix Columns field.

This way, users pick which level to analyze, and the view updates accordingly.

Configure the Matrix Visual

Drag the new Date or Field Parameter hierarchy into the Columns area of the matrix visual.

This enables drill-up/down icons and proper level display when filtered.

Use Date-based Slicer

Place the Date or Date Hierarchy column into a slicer.

Filters the visual correctly but the hierarchy drives the layout—so selecting a month filters only that period, while still showing the correct column level in context.

Find the attached .pbix file for your reference.

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

Best Regards,
Sreeteja.
Community Support Team