Show missing data in table

[KH_Mike]

Hi All,

I have a dataset like below.

Year	Type	Amount
2020	A	10
2020	B	20
2020	C	30
2020	D	40
2020	E	50
2021	A	60
2021	B	70
2021	C	80

Now, I create a measure to calculate the Last Year (2020) result and show it together with this year data like below.

Slicer = 2021

Type	This Year	Last Year
A	60	10
B	70	20
C	80	30

However, I would like the "Type" also contain what 2020 have but 2021 no record like below.

Type	This Year	Last Year
A	60	10
B	70	20
C	80	30
D	0	40
E	0	50

Anyone how to do it?

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[KH_Mike]

That what I need. Thank you.

[Ashish_Mathur]

You are welcome.

[KH_Mike]

Hi @ALLUREAN , @PC2790 ,

Sorry that I tried the way you provided, still not able to do it.

[PC2790]

Try adding +0 in your measure formula and see if it works

[ALLUREAN]

Hi, @KH_Mike 

Can you try this? Right click on Type field:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data