Filtering stacked column and line chart, displaying despite null values.

[peyton]

Hello,

I am attempting to create a stacked column and line chart that can be filtered by an account table.

Currently, the account table will filter and present the total open volume as the line and closed volume as the columns. When filtering by the account, it will show the full line across all months if closed volume values exist for all months (first image) but does not show the full line if there are no closed volume values for all months (second image).

It is possible to present the line and columns across all months when filtering despite some accounts not having values for both axis?

[Anonymous · Accepted solution]

Hi @peyton ,

Could you try to click the 'Show items with no data' ?

Best Regards,

Wearsky

[peyton]

This is exactly what I was looking for. Thank you for the solution.

[Ashish_Mathur]

Hi,

I am not sure but see if this measure works

Measure = coalesce([your measure],0)