Forum Discussion
Show weeks without data in a visual
I have a table named 'Database' with data below:
| Year | Quarter | Week | Phone Brand | Phones Sold |
| 2020 | 20Q1 | 2020_1 | A | 7 |
| 2020 | 20Q3 | 2020_34 | A | 56 |
| 2020 | 20Q4 | 2020_41 | B | 61 |
| 2021 | 21Q2 | 2021_20 | B | 24 |
| 2021 | 21Q2 | 2021_26 | C | 12 |
| 2021 | 21Q3 | 2021_32 | C | 19 |
| 2021 | 21Q4 | 2021_40 | C | 8 |
My current column chart only displays weeks with data. I want to display a visual with weeks 2020_1-2021_40, given that weeks that are not in table (e.g. 2020_2-33, 2020_35-40, 2021_1-19.....) will be shown as well.
2 Replies
Anonymous ,
You need to have separate date dimension table to get the continuous week numbers.
https://radacad.com/power-bi-date-or-calendar-table-best-method-dax-or-power-query
Thanks,
Arul
