powerBI Desktop - data type changed in 'Data' tab doesn't reflect in the charts in 'Report' tab

[cheriemilk]

Hi team,

1. I have loaded the data from MongoDB to powerBI Desktop. In the data loaded, there's a column called '_time' which actually is a timestamp. The values are like this "3/29/2022 2:53:36 PM".

2. Then I switch to 'Data' tab, and a)changed the data type for '_time' column from 'Date/time' to 'Date'. for example, the value is changed from "3/29/2022 2:53:36 PM" to "3/29/2022". b) changed the Date format to 'm/d/yyyy'

Here is the screenshot before and after changed.

a) before change

b) after change

1. Then I go to report tab to create a line chart by selecting '_time' as axis and 'count of userID' as Y axis. The expected chart I want is to get the count of userID by daily. But actually, powerBI doesn't return the expected result to me. It looks like that powerBI still calculate the count of UID by timestamp because almost all value is 1 for a time.

Actual Chart: 

Expected Chart: 

[amitchandak · Accepted solution]

@cheriemilk , Changing Data type in DAX will not remove timestamp. Do that in power query (That will remove timestamp)

Or create a new column

Date only = datevalue([Datetime])

[cheriemilk]

Thanks for the solution