Date Chart to show changes on the day, repeating previous day if no value

[techno]

Looking for a solution to display a chart that shows value changes on the respective date.

i.e.

Sales

01 Dec 2023		10
05 Dec 2023		15
06 Dec 2023		15

Having the chart display horizontal links between the dates.

the 2nd, 3rd and 4th of December, even there is no value, should be treated as though they have the same value as the 01 Dec, thus only chaning on the 5th when a new different value is present.

Can this be configured directly on a chart visualization or will we need additional measures etc.

Wanting to keep things as simple as possible.

Getting the same value provided in the data set cannot happen, which would resolve this eaily enough.

[amitchandak · Accepted solution]

@techno , Create a date/calendar table and then join the date of your table with date of date table. Use date from date/calendar table in visual, measure, and slicer

Last Sales = CALCULATE(lastnonblankvalues('Date'[Date], SUM(Sales[Amount])) ,filter(all('Date'),'Date'[date] <=max('Date'[date])))

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[techno]

@amitchandak Thank You.

Apologies on the delay

Got this working with a slight adjustment:
Last Sales = CALCULATE(lastnonblankvalue('Date'[Date], SUM('Sales'[Amount])) ,filter(all('Date'),'Date'[date] <=max('Date'[date])))