Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

New Member

Show whole year while slicing on one month - DAX



I am trying to get whole year for a diagram when using the filter "month year".

For example when using the filter 202201 I want the whole 2022 to result in values for my diagram. How can I do that?

I have one date table "Calendar" and I have one Sale table "DimSale".


Greatful for all help!



Regular Visitor

Hello there,

If you are using a monthly year filler, ensure your calendar table has a combination of the month and year. Power BI creates the relation between the calendar table and sale table data, and then you can use the month-year filter on your diagram.

I hope this is helpfulfor you.

Super User
Super User

you would create a measure that calculates the value accordingly (for example via REMOVEFILTERS(month)

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.