Automatically Exclude the Current (Incomplete) Month

[hemmimann]

Hi everyone,

I’m building a report in Power BI that shows the amount of income received, broken down by year and month. However, I've noticed that when the current month is not yet complete, the latest month shows an unnatural drop in the graph — simply because not all data has been collected yet.

I want to automatically exclude the current month from the visuals, so for example:

• On June 17, 2025 – the chart should only display data up to May 2025.

• In July – it should automatically include June, and so on.

Is there a way to configure the filter pane (e.g., using my date table) to only include data before the first day of the current month?

I’d like to keep all full months from previous years and current year — up to last complete month.

[v-karpurapud]

Hi @hemmimann 

We are following up to see if you have had the chance to review the information provided. If you have any further questions, please do not hesitate to contact us. Could you confirm whether your query has been resolved? If so, kindly mark the helpful response and accept it as the solution to assist other community members in resolving similar issues more efficiently. If not, please provide detailed information so we can better assist you.

Thank You.

[v-karpurapud · Accepted solution]

Hi @hemmimann 

Welcome to the Microsoft Fabric Community Forum.
 

To automatically exclude the current  month from Power BI visuals and ensure that only fully completed months are shown, you can enhance Date table with a calculated column using the following DAX expression as mentioned by @johnt75 

BeforeCurrentMonth = 'Date'[Date] <= EOMONTH(TODAY(), -1).
 

This logic dynamically evaluates each date and returns TRUE only for dates that fall before the first day of the current month. For example, if today is June 17, 2025, it will mark all dates up to May 31, 2025, as TRUE, effectively excluding the entire month of June. Once July begins, June will automatically be included. You can then apply this column as a filter at the visual, page, or report level by setting BeforeCurrentMonth to TRUE. This ensures your visuals always reflect only complete months of data, preventing misleading dips due to partial month data.

If this response resolves your query, kindly mark it as Accepted Solution to help other community members. A Kudos is also appreciated if you found the response helpful.

Thank you for being part of Fabric Community Forum.

Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.

[johnt75]

Add a column to your date table e.g.

Before current month =
'Date'[Date] <= EOMONTH ( TODAY (), -1 )

You can then use this as a report level filter, set to true.