I'm trying to create a monthly bar chart that includes months where there were no transactions. The continuous scale option seems to only work for date fields.
including using Aggr({$<[Year Month]=P({1}[Year Month])>}
While I can see in a Filter Pane it actually generates the full set of records I can't get it to work in a table because the missing months are grey. I'm including null & zero values in my options.
(I was selecting on Parent Project but there is a project hierarchy to consider)