Forum Discussion

AgoZ_KH's avatar
AgoZ_KH
Icon for Resolver I rankResolver 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
AgoZ_KH's avatar
AgoZ_KH
Icon for Resolver I rankResolver 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
Icon for Community Support rankCommunity 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
    Icon for Resolver I rankResolver 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.