Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My dimension is "Month" and I have a measure that looks like this:
Sum(Sales)
The resulting table looks like this:
Month | Sum(Sales) |
Jan | 3 |
March | 1 |
April | 1 |
June | 5 |
You can see that I sold three cars in January, one car in March and April, and five cars in June. However, I did not sell any cars in February or May, and that's why they don't appear in the table above.
When I plot this as a bar chart there are missing values for February and May. Are there any way to force values of zero for these two months, so the months will display on my bar chart?
Do you have a master calendar in your data model, you will need all the months available in your dimension through master calendar to achieve the required behavior.