KPI visualization - incorrect distance between indicator and target
The KPI shows different disances when I automate indicator and target. But when I set them manually, it shows a correct distance. Please tell me where my mistake is.
I have a table with prices which update weekly. In KPI I need to show the last day price as an indicator and the first day price as a target. The KPI difference will be a subtraction between the last day and the first day.
There are also filters on this visual: a slicer " Delivery date" and a visual filter " Product used in charts"
1) in this measure I set dates manually and it shows the difference correctly:
But every week I need to enter new dates manually, so I decided to automate.