Continuous X axis for [Year Month]

GregWP — Fri, 01 Nov 2019 09:59:41 GMT

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.

topic Continuous X axis for [Year Month] in App Development

Continuous X axis for [Year Month]