So what i need to do to see all 12 months in my graph even with zero or null measures??
Did you checked show null values option in Add on's tab
try this in front end
What is YearMonth?
okay. try with Synthetic dimensions create variable for months and use that in value list.. like below
YearMonth field is working?
I haven't got this field
Change your Expression to show something other than 0; so suppress zero doesn't take effect
OK, I think you are using the year month field from your fact table and those missing months don't exist in your FACT table.
Use the year month field from your Master Calendar that relates to your fact, the same approach will work
So there is no way to show up all months without using master calendar???
It's so sad... I prepared to use this in very last moment...
How can we show something that doesn't exist ,
Right now the chart is aggregating over 7 possible dimension valu