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.