Forum Discussion
Helper IIIArea Chart - How to show zero if no record?
Hi All,
I have a list of record like below and would like to show it as Area / Line Chart. However, the Items "C" don't have any record in 2017, 2018 & 2019 but the show will linkup the record from 2016 to 2020. Is it possible to show it as 0 in chart?
| Year | Items | Sales |
| 2015 | A | 10 |
| 2016 | A | 20 |
| 2017 | A | 30 |
| 2018 | A | 40 |
| 2019 | A | 50 |
| 2020 | A | 60 |
| 2015 | B | 20 |
| 2016 | B | 40 |
| 2017 | B | 60 |
| 2018 | B | 80 |
| 2019 | B | 100 |
| 2020 | B | 120 |
| 2015 | C | 30 |
| 2016 | C | 60 |
| 2020 | C | 100 |
Hey KH_Mike ,
that is possible when you use a dimensional date table. See the following article on how to do that:
Power Bi for Beginners: How to create a Date Table in Power Bi - Softcrylic
Then you have to use the column from the date table and set the axis to "continuous" and it will show the zero values.
If you need any help please let me know.If I answered your question, I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
1 Reply
- selimovd
Most Valuable Professional
Hey KH_Mike ,
that is possible when you use a dimensional date table. See the following article on how to do that:
Power Bi for Beginners: How to create a Date Table in Power Bi - Softcrylic
Then you have to use the column from the date table and set the axis to "continuous" and it will show the zero values.
If you need any help please let me know.If I answered your question, I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic