Forum Discussion
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
Solution SageHi Anonymous
I tried to replicate your scenario with my dataset. Here's a solution that might help you:
You need to:
Create a Field Parameter containing your time columns (in my case: Year, Quarter, Month)
Use this parameter in your slicer
In the matrix visual, place the parameter in the Columns field area
This approach will automatically handle the hierarchy switching based on slicer selection.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.
thanks for your responce, after creating feild parameter if we use any date range like jan to feb 2025 does it work ?
- Elena_Kalina
Yes, the time filtering works in my table setup. For testing, I set up parameters not just for year, month, and quarter but also more similar to what you’re using in your example