Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hello!
I have a report that is structured like this:
Table (Matrix Visual):
Where I want the Parameter Field for my Dimension called DateAxis to change context to month when a specific year is selected:
I've tried many different ways, but haven't found a way to do this in one easy click in my Calendar - Year slicer. I am not the most experienced at DAX so I'm hoping someone knows a good way to enable me to set it up without having to interact with the DateAxis field, like this:
Thanks in advance,
Audun
I hacked together a functioning solution. It is not optimal but solves this concrete task.
I did it by creating a table called DateAxisSwitch:
Modifying my DateAxis:
And connecting the Year column of DateAxisSwitch table to my Calendar and DateAxisKey with DateAxisOrder of DateAxis.
Now it looks like this without a year selected:
And this with:
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 18 | |
| 10 | |
| 9 | |
| 8 | |
| 7 |
| User | Count |
|---|---|
| 50 | |
| 38 | |
| 36 | |
| 25 | |
| 21 |