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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Cluster Column Chart Display Blank Date.

Hi All,

       I need to display the blank date values as zero.

 

Ex: 

      

kalikumar_0-1700200608442.png

       In this above image i select date 2023-02. 

       The Scenario is if user select date, That date before 12 month shold be shown in the visual.

       But, the july month data is not available in the data. If the date is blank i need to show the bar is zero.

       How to achieve this logic.

       Please help me. Thanks in Advance : )

1 REPLY 1
Bmejia
Super User
Super User

Add +0 at the end of your formula.
example

SUM('Table'[Value])+0

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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