Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Usage Metrics Missing Dates

I have a usage metrics report set up but we seem to be missing 16 days from 12th to 27th:

Is there something I can do to get these dates into the report?

Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , Anonymous 

    Dates inside Usage Metircs are hierarchical, which saves all dates that you can select "Show items with no data" to display the all date in table .

     

    Best Regards,

    Aniya Zhang

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

     

3 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    3 years ago

    Are your dates coming from a Dates table (connected 1:m to the Fact table)?  If so, you can add zero (+0) to the measure in the visual and powerbi will show the dates 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      I can't change any of the tables or measures as it's the usage metrics report that Power BI automatically generates.

      • v-yueyunzh-msft's avatar
        v-yueyunzh-msft
        Community Support
        3 years ago

        Hi , Anonymous 

        Dates inside Usage Metircs are hierarchical, which saves all dates that you can select "Show items with no data" to display the all date in table .

         

        Best Regards,

        Aniya Zhang

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