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
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.

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

    Hi, iamflamingjune 

     

    I think you need to create a date table in the data source. It is unsupported to create a calculated table when using live connect mode.

     

    Generally, your data model will contain a calendar table. It is better to aggregate data by year and month using columns of a calendar table (containing one row for each day) instead of extracting the date parts from a single column of type date or datetime in calculated columns. You obtain a model wherein all date attributes are included in a separate table making it easier to browse data using a generic client, and you can use special DAX functions that perform time intelligence calculations. Moreover, most of the time intelligence functions require a separate Date table to work correctly

     

    Best Regards

    Allan

     

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