Forum Discussion
Showing Dates even when Value is Blank
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.
Hi Anonymous
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.
9 Replies
- pankajnamekar25
Super User
Hello Anonymous
You option shown in image
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
- pankajnamekar25
Hey you can apply filter from Filter pane
v-karpurapudCommunity Support
Hi Anonymous
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.- v-karpurapud
Hi Anonymous
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 Anonymous
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!
