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

     

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