My values are changing depending on column order?

[innesccm]

Hi All

Power BI is changing the values on one column depending on the date column date being sorted asc or desc. Has anyone come across this issue before? 

Using Redshift as data source - this happens both on PBi service and when I use the online report as data source

Dates Descending - Incomplete dataDates Ascending

[v-yuta-msft]

Hi innesccm,

So your operation before this issue happens is that you click the column value, right? Which one is the correct value based on your raw data? Are you using import or direct query? If you are using direct query mode, check if the data in redshift has been changed. Also, you can refer to the documentation about limit if redshift database.

https://docs.aws.amazon.com/redshift/latest/mgmt/amazon-redshift-limits.html.

Regards,

Jimmy Tao