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 d...
Need Help
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.

      • iamflamingjune's avatar
        iamflamingjune
        Frequent Visitor
        6 years ago

        v-alq-msft My data source is an excel spreadsheet, which i connect to it live from the workspace.
        Im not able to create the calculated table for the date, as you show, that section is greyed out.

        Is there a work around ?

        I appreciate your patience.