Cumulative Values Not Showing Correctly On Date Axis

[sperry]

I would like to present a graph that shows the cumulative number of booster vaccinations required by month. created a 'dummy' model containing the scenario. Please see model in link below. I seem to be getting some spurious data for months where I am expecting no data.

CumulativeForForum.pbix

[v-yiruan-msft · Accepted solution]

Hi @sperry ,

Please try to update the formula of measure [Total Cumulative Boosters Required Maori] as below and check whether it can get your expected result. You can find the details in the attachment.

Note: The part with red font is updated one...

Total Cumulative Boosters Required Maori =

IF (

ISBLANK ( [Total Cumulative Eligible Booster Māori] )

|| ISBLANK ( [Total Cumulative Boosters Administered DHB Residence Māori] ),

BLANK (),

( 'COVID-19 Vaccinations DHB of Residence'[Total Cumulative Eligible Booster Māori] - 'COVID-19 Vaccinations DHB of Residence'[Total Cumulative Boosters Administered DHB Residence Māori] )

)

Best Regards

[lbendlin]

Your data has blank "Eligible Booster Date"  fields.

[sperry]

You are absolutely right - I use the data for several reasons so some rows are validly blank for the "Eligible Booster Date"  fields. Not sure how this helps me. If I filter out the blank dates then incorrect values are shown in the column chart visual

[v-yiruan-msft · Accepted solution]

Hi @sperry ,

Please try to update the formula of measure [Total Cumulative Boosters Required Maori] as below and check whether it can get your expected result. You can find the details in the attachment.

Note: The part with red font is updated one...

Total Cumulative Boosters Required Maori =

IF (

ISBLANK ( [Total Cumulative Eligible Booster Māori] )

|| ISBLANK ( [Total Cumulative Boosters Administered DHB Residence Māori] ),

BLANK (),

( 'COVID-19 Vaccinations DHB of Residence'[Total Cumulative Eligible Booster Māori] - 'COVID-19 Vaccinations DHB of Residence'[Total Cumulative Boosters Administered DHB Residence Māori] )

)

Best Regards

[sperry · Accepted solution]

Perfect - works a treat..thanks for that