Display average value from previous Year/Quarter/Month if current is empty

[HiriKiri]

Good day everyone.

I'm new in Power Bi, so hope for your help 🙂

I have a line chart that displays a few average values by dates (X-axis - DateTime column, Y-axis - a few other columns with selected 'Average' option)

I use Categorical type, so the point is missing if there is no data in appropriate datetime interval:

I have to replace this logic to display data from previous Year/Quarter/Month (due to selected Hierarchy level) in case if current is empty to avoid these 'gaps'.

As I understand, I have to use Measure, but I've tried to use something like this: Measure = IF(ISBLANK(AVERAGE(Table[Value3])), 0, AVERAGE(Table[Value3]))

And i can't understand what should be instead of '0' to get previous calculation data (due to screen, in 2021 Qtr3 should be displayed '2' (Average value from 2021 Qtr2), so 2021 Qtr2, 2021 Qtr 3 and 2022 Qtr3 will be connected without gaps)

Could someone help me with this moment (or maybe there is exists another solution)?

[v-kkf-msft]

Hi @HiriKiri ,

Please provide some sample data.

[HiriKiri]

Hi @v-kkf-msft ,

My bad. Forgot about this)

Here is some data: