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 was shipped, Shipment Week is Shipment Date rounded to the previous sunday. My visuals are on an itemnumber-by-itemnumber & week-by-week basis.

 

My red < lines show periods where entire weeks have no shipments. When I visualize this in a line graph, what I'd like is for that to show as 0, because 0 of that item shipped that week. What it does instead is it draws a continuous line from the weeks with data, like so:

 

 

So yeah, where the red v's are is where there is no shipments for that week. Naturally I'd like to see that go down to 0 rather than show a continuous line.

 

Do you guys have any suggestions?

 

  • 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 

     

6 Replies

  • Baskar's avatar
    Baskar
    Icon for Resident Rockstar rankResident Rockstar

    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 

     

     

     

     

      • Baskar's avatar
        Baskar
        Icon for Resident Rockstar rankResident Rockstar

        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