Showing Dates even when Value is Blank

[LPlenty]

Hi All,

I have a 12 month rolling table as below, but need the months with no value to still appear, as per 2nd graph (Excel). How can I achieve this please?

thanks in advance.

[v-karpurapud]

Hi @LPlenty 

Could you please confirm if you have raised the support ticket and if the issue has been resolved after raising a support ticket? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.

Thank you!

[v-karpurapud]

Hi @LPlenty 
Thank you for reaching out to the Microsoft Community Forum.

Consider the following steps to resolve the issue:

1.Make sure date table  includes dates only up to 31/03/25 and mark it as a "Date Table" in Power BI.

2. Verify if there is an active relationship between the date columns of the date table and the fact table.

3.Then Use the date table’s date column for visuals and apply the "last 12 months" filter to it.

4.Now Filter out any dates after 31/03/25 in the fact table, then refresh the model to ensure the visual shows only April 2024 to March 2025.

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

A special thanks to @pankajnamekar25 for responding on this topic.
 Thank You.

[LPlenty]

Thank you. Unfortunately all those steps are in place and this is still happening. 

My fact table also has no dates after March 2025, nor does my date table as ending March25. 

[v-karpurapud · Accepted solution]

Hi @LPlenty 

Thank you for your patience and for trying all the recommended steps. Since the issue persists despite ensuring that the Date Table is correctly configured, relationships are active, missing data handling is applied, and "Show Items with No Data" is enabled, this appears to be a product-related behavior affecting the visual rendering.

we recommend raising a support ticket with Microsoft for further investigation and resolution. Their support team will be able to assist you more effectively.You can submit a ticket through the Microsoft Power BI Support Portal:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thank you.
 

[v-karpurapud]

Hi @LPlenty 

We are following up once again regarding your query. If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[LPlenty]

I already have a relative date filter applied to the last 12 months, with my date table ending 31/03/25. So not sure why its doing this. Any ideas?

[pankajnamekar25]

Hello @LPlenty 

You option shown in image

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[LPlenty]

Amazing thank you! Only problem now is it shows a longer date period, despite my date table only going to March25. Any idea why or how to solve? thank you.

[pankajnamekar25]

Hey you can apply filter from Filter pane