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 

     

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.

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

        Accepted your solution. It worked! Thanks pal.