Forum Discussion
YOY visualization question
The attached is only a rough draft. What you really want is a proper calendar table in your data model.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
| ID | myDate(Year) | myDate(Quarter) | myDate(Month) | myDate(Day) | myBitField |
| 1 | 2024 | Q1 | Jan | 1 | 1 |
| 2 | 2024 | Q1 | Jan | 2 | 1 |
| 3 | 2024 | Q1 | Jan | 3 | 0 |
| 4 | 2024 | Q1 | Jan | 4 | 0 |
| 5 | 2024 | Q1 | Jan | 5 | 0 |
| 32 | 2024 | Q1 | Feb | 1 | 1 |
| 33 | 2024 | Q1 | Feb | 2 | 0 |
| 34 | 2024 | Q1 | Feb | 3 | 1 |
| 35 | 2024 | Q1 | Feb | 4 | 0 |
| 36 | 2024 | Q1 | Feb | 5 | 0 |
| 61 | 2024 | Q1 | Mar | 1 | 1 |
| 62 | 2024 | Q1 | Mar | 2 | 1 |
| 63 | 2024 | Q1 | Mar | 3 | 0 |
| 64 | 2024 | Q1 | Mar | 4 | 1 |
| 65 | 2024 | Q1 | Mar | 5 | 0 |
| 92 | 2024 | Q2 | Apr | 1 | 1 |
| 93 | 2024 | Q2 | Apr | 2 | 0 |
| 94 | 2024 | Q2 | Apr | 3 | 0 |
| 95 | 2024 | Q2 | Apr | 4 | 1 |
| 114 | 2024 | Q2 | Apr | 23 | 1 |
| 122 | 2024 | Q2 | May | 1 | 1 |
| 123 | 2024 | Q2 | May | 2 | 1 |
| 124 | 2024 | Q2 | May | 3 | 0 |
| 125 | 2024 | Q2 | May | 4 | 0 |
| 126 | 2024 | Q2 | May | 5 | 1 |
| 153 | 2024 | Q2 | Jun | 1 | 1 |
| 154 | 2024 | Q2 | Jun | 2 | 1 |
| 155 | 2024 | Q2 | Jun | 3 | 0 |
| 156 | 2024 | Q2 | Jun | 4 | 0 |
| 157 | 2024 | Q2 | Jun | 5 | 1 |
| 183 | 2024 | Q3 | Jul | 1 | 1 |
| 184 | 2024 | Q3 | Jul | 2 | 1 |
| 185 | 2024 | Q3 | Jul | 3 | 1 |
| 186 | 2024 | Q3 | Jul | 4 | 0 |
| 187 | 2024 | Q3 | Jul | 5 | 0 |
| 214 | 2024 | Q3 | Aug | 1 | 1 |
| 215 | 2024 | Q3 | Aug | 2 | 1 |
| 216 | 2024 | Q3 | Aug | 3 | 1 |
| 217 | 2024 | Q3 | Aug | 4 | 0 |
| 218 | 2024 | Q3 | Aug | 5 | 0 |
| 245 | 2024 | Q3 | Sep | 1 | 1 |
| 246 | 2024 | Q3 | Sep | 2 | 1 |
| 247 | 2024 | Q3 | Sep | 3 | 1 |
| 248 | 2024 | Q3 | Sep | 4 | 0 |
| 249 | 2024 | Q3 | Sep | 5 | 0 |
| 275 | 2024 | Q4 | Oct | 1 | 0 |
| 276 | 2024 | Q4 | Oct | 2 | 1 |
| 277 | 2024 | Q4 | Oct | 3 | 1 |
| 278 | 2024 | Q4 | Oct | 4 | 1 |
| 279 | 2024 | Q4 | Oct | 5 | 0 |
| 306 | 2024 | Q4 | Nov | 1 | 0 |
| 307 | 2024 | Q4 | Nov | 2 | 1 |
| 308 | 2024 | Q4 | Nov | 3 | 1 |
| 309 | 2024 | Q4 | Nov | 4 | 1 |
| 310 | 2024 | Q4 | Nov | 5 | 0 |
| 336 | 2024 | Q4 | Dec | 1 | 0 |
| 337 | 2024 | Q4 | Dec | 2 | 0 |
| 338 | 2024 | Q4 | Dec | 3 | 1 |
| 339 | 2024 | Q4 | Dec | 4 | 1 |
| 340 | 2024 | Q4 | Dec | 5 | 1 |
| 367 | 2025 | Q1 | Jan | 1 | 1 |
| 368 | 2025 | Q1 | Jan | 2 | 1 |
| 369 | 2025 | Q1 | Jan | 3 | 1 |
| 370 | 2025 | Q1 | Jan | 4 | 0 |
| 371 | 2025 | Q1 | Jan | 5 | 0 |
| 429 | 2025 | Q1 | Feb | 1 | 1 |
| 430 | 2025 | Q1 | Feb | 2 | 1 |
| 431 | 2025 | Q1 | Feb | 3 | 1 |
| 432 | 2025 | Q1 | Feb | 4 | 0 |
| 433 | 2025 | Q1 | Feb | 5 | 0 |
| 485 | 2025 | Q1 | Mar | 1 | 1 |
| 486 | 2025 | Q1 | Mar | 2 | 1 |
| 487 | 2025 | Q1 | Mar | 3 | 1 |
| 488 | 2025 | Q1 | Mar | 4 | 1 |
| 489 | 2025 | Q1 | Mar | 5 | 0 |
| 547 | 2025 | Q2 | Apr | 1 | 1 |
| 548 | 2025 | Q2 | Apr | 2 | 1 |
| 549 | 2025 | Q2 | Apr | 3 | 1 |
| 550 | 2025 | Q2 | Apr | 4 | 1 |
| 551 | 2025 | Q2 | Apr | 5 | 0 |
| 552 | 2025 | Q2 | Apr | 23 | 1 |
The attached is only a rough draft. What you really want is a proper calendar table in your data model.