Forum Discussion

iamflamingjune's avatar
iamflamingjune
Frequent Visitor
6 years ago

How do i plot a date with no values

I have a simple graph, which counts all issues logged on a specific day.

I filter the graph, showing the last 7 days worth of issues, however because there are no issues reported on these days, it doesnt move the date along..

 

So in the example below, 29th June was the last reported issue.. its now the 2nd July and i would like the graph to show zero values for the last few days... 

 



 

Ive got this ticked

Any advice would be appreciated

Need Help

7 Replies

    • iamflamingjune's avatar
      iamflamingjune
      Frequent Visitor
      6 years ago

      Any advice on how i would do that... i have followed various tutorials with no luck

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    Hi, iamflamingjune 

     

    Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

     

    Table:

     

    Calendar(a calculated table):

    Calendar = CALENDARAUTO()

     

    There is a relationship between two tables. You may create a measure as below.

    Result = 
IF(
    ISBLANK(SUM('Table'[Number of issues])),
    0,
    SUM('Table'[Number of issues])
)

     

    Today is 7/3/2020. So the range is 7/27/2020-7/3/2020.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

    • iamflamingjune's avatar
      iamflamingjune
      Frequent Visitor
      6 years ago

      Thank you v-alq-msft for taking the time to look into this.

      Could you upload the pbix file, so i can reference the measures you have indicated above.

      Will accept this as a solution, once i have had a chance to test.