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

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.

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