Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, everyone!
So what i need to do to see all 12 months in my graph even with zero or null measures??
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
Did you checked show null values option in Add on's tab
try this in front end
in dimension
=Month(YearMonth)
Change your Expression to show something other than 0; so suppress zero doesn't take effect
= if(sum(Expression)=0,0.0001,sum(Expression))
Result:
What is YearMonth?
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
okay. try with Synthetic dimensions create variable for months and use that in value list.. like below
“=if(ValueList($(VarMonths…”
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...