Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Cluster Column Chart Display Blank Date.

Hi All,

       I need to display the blank date values as zero.

 

Ex: 

      

       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

  • Add +0 at the end of your formula.
    example

    SUM('Table'[Value])+0