Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
That what I need. Thank you.
You are welcome.
Try adding +0 in your measure formula and see if it works
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
Proud to be a Super User!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
104 | |
99 | |
97 | |
41 | |
38 |
User | Count |
---|---|
151 | |
123 | |
79 | |
73 | |
71 |