Forum Discussion

ytc-reports's avatar
ytc-reports
Icon for Helper I rankHelper I
9 years ago
Solved

Data table with missing date ranges - how to visualize 0s?

Hi guys! Having a bit of trouble with what I thought would be a simple, common requirement.   I've got a data table that looks something like this: Shipment Date is the date that the item wa...
Need Help
  • Baskar's avatar
    Baskar
    9 years ago

    My point of view , what u r trying to show that is not possible is this chart or visuals in power BI default chart.

     

    Next, 

     

    1. if u measure is calculated column , add one if condtion like 

     

    Measure = IF ( Isblank( sum(Column_Name)), 0 , sum(Column_Name) )

     

    try this, let me know 

     

Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
9 years ago

Cool dude,

 

1. Without data how can we show as 0.

 

2. If want to show missing date in X-Axis , we can do , choose "Continuos" in X-Axis Property pls refer image 

 

 

 

 

ytc-reports's avatar
ytc-reports
Icon for Helper I rankHelper I
9 years ago

Thanks man, but it's already set to 'continuous'

  • Baskar's avatar
    Baskar
    Icon for Resident Rockstar rankResident Rockstar
    9 years ago

    My point of view , what u r trying to show that is not possible is this chart or visuals in power BI default chart.

     

    Next, 

     

    1. if u measure is calculated column , add one if condtion like 

     

    Measure = IF ( Isblank( sum(Column_Name)), 0 , sum(Column_Name) )

     

    try this, let me know 

     

    • ytc-reports's avatar
      ytc-reports
      Icon for Helper I rankHelper I
      9 years ago

      That might be the solution. Give me a bit to check it out and I'll get back to you.

      • Baskar's avatar
        Baskar
        Icon for Resident Rockstar rankResident Rockstar
        9 years ago

        Am waiting for u my dear friend.