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.
I tried using variations of this:
Aggr( MaxString({1<PRNT_PROJ_NO=,[Year Month]={">=$(=Min([Year Month]))<=$(=Max([Year Month]))"}>} [Year Month]), [Year Month])
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)
All ideas appreciated.
