cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
9192gks
Helper III
Helper III

Date and Datetime field different behaviour

Hi everyone, 

When i am using Date field then i am able to get the straight tooltip line in my line chart when i hover on a x-axis.

9192gks_0-1624648296962.png

But this tooltip behaviour changes when i use datetime field instead of date field. There are blank values when i use date and datetime field as i have attached the matrix view of both the charts.

9192gks_1-1624648535513.png

Please guide me through, I have been struggling for past 1 week.

@amitchandak  @parry2k @Fowmy @Jihwan_Kim @selimovd 

 

 

1 ACCEPTED SOLUTION
9192gks
Helper III
Helper III

SOLUTION : TURN OFF THE HIGH DENSITY SAMPLING UNDER GENERAL  (-_-)

View solution in original post

3 REPLIES 3
9192gks
Helper III
Helper III

SOLUTION : TURN OFF THE HIGH DENSITY SAMPLING UNDER GENERAL  (-_-)

9192gks
Helper III
Helper III

Hi @Pragati11 thanks for responding

This report is already published in the power bi service and its been done on the datetime field so i believe it's doable using datetime. I am not concerned about values, i just want the tooltip to behave the same way when i use the date

Pragati11
Super User
Super User

HI @9192gks ,

 

Datetime is more detailed view when compared to date. therefore when you use datetime value on your chart, it shows you different values.

But when you use date on your chart, it aggregates your values for a particular date value like for 1st January 2021.

On the other hand, datetime will split your value for every time value for 1st January 2021.

 

In such scenarios, you should use the granualrity by which you want to show your data like Monthy, Daily, Hourly, etc.

 

Thanks,

Pragati

Best Regards,

Pragati Jain

MVP logoDACertAzCert

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!