Forum Discussion

AgoZ_KH's avatar
AgoZ_KH
Resolver I
4 years ago

Timeline chart view Date when timestamp is empty

Hi community! Have a fun and nice day!   I'm facing with this issue.   I have an input data file with daily measure. Sometimes the daily misure are missing. So when I plot the timeline chart same...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Would your problem be solved if you add +0 to the end of your measure? 

AgoZ_KH's avatar
AgoZ_KH
Resolver I
4 years ago

For sure  I didn't make myself clear!!

My data (measures) are collected in a DB from an external source. If source have measures in the day these are registred on the DB with the datastamp (i.e. 02/22/2020 14:30) if not simply there is no data on the DB.

I cant'control this and put blank data in the DB if there are not measures for a specific day.

Thanks you!

  • Icey's avatar
    Icey
    Community Support
    4 years ago

    Hi AgoZ_KH ,

     

    Which type of visual are you using? Can the type of X-axis be set as "Continuous" instead of "Categorical"?

     

     

    In addition, you can try to create a new measure in Power BI like below to meet your requirements:

    New Measure in Power BI = 
SUM ( 'YourTable'[Your old measure] ) + 0  //If your old measure has become a column in Power BI.

     

     

     

    Best Regards,

    Icey

     

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

    • AgoZ_KH's avatar
      AgoZ_KH
      Resolver I
      4 years ago

      Hi Icey ! 

      I discover, by your posted image, I didn't have the last version of Desktop pBI!! So I download it. But I don't have anyway the choice to set X-Axis. I use the object Graph Line. Which kind of grafic are you using?

      Best regards

      A.