Removing Aggregation from date column in power bi

[BayanKhalaf]

I have a report with a matrix table as a visual. I added a date column to the values section, but it is being aggregated and displaying a date that is one day earlier than the actual date. I want it to show the exact date.

Even though I have set the summarization to "Don't Summarize," it still isn't working. How can I fix this problem?

[Anonymous · Accepted solution]

Hello @bhanu_gautam .Thanks for your concern about this issue.
And I would like to share some additional solutions below.
Hi,@BayanKhalaf .I am glad to help you.
According to your description, you created a date column (Date/Time type) and tried to display it in the matrix visual (in the “value” field), but there is a problem, it aggregates the values and displays the previous day's values incorrectly!
This is actually a strange problem
I would like to check your current visual presentation, are you using a matrix or a table to present the data?
Because if it's a value field in a matrix, the data in that position must be aggregated, or you can choose to show the first value or the last one
like this.

For your  question:
1. Can you recreate a new date column to display and see if the original date column is the problem that is causing the data to be displayed incorrectly.
You can try to recreate a new date column using the dax code, and use this newly created date column instead of the original problematic column (use FORMAT and DATEVALUE functions to create a new date column)
2. Re-check whether there are other filters in the visual you have placed, resulting in the date in the visual does not display the correct data
3. Please check your power query in the relevant processing operations, to confirm that the data type and specific data does not appear to be a problem.
If you can, please provide the relevant pbix file (without sensitive data) or screenshot (need to include data type, filter conditions and other information) which can help to solve your problem.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[BayanKhalaf]

Hello @Anonymous,

Thank you for you suggestions!

I created a new column then i used Date.AddDay function and it worked perfectly fine.

[BayanKhalaf]

it's Date/time 

i tried to change it to date but the problem was still the same.

[bhanu_gautam]

@BayanKhalaf , Is it date column or date time column