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 days aren't displayed. Suppose you haven't measure between 5 and 9 february my timeline went: 1/2/3/4/10/11/12 and so on.

My problem is to plot every day in the week also if the timestamp is empty (i.e. measure are 0).

 

Try to make a calendar table and creating logical function to manage the problem, without success! Can onyone help me?

Thanks in advance!

 

Need Help
Tips and Tricks

7 Replies

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