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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kalikumar
Helper II
Helper II

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
Solution Specialist
Solution Specialist

Add +0 at the end of your formula.
example

SUM('Table'[Value])+0

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors