Forum Discussion

peyton's avatar
peyton
Regular Visitor
1 year ago
Solved

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

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's avatar
    Anonymous
    1 year ago

    Hi peyton ,

     

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

     

    Best Regards,

    Wearsky

3 Replies

  • Hi,

    I am not sure but see if this measure works

    Measure = coalesce([your measure],0)

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi peyton ,

     

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

     

    Best Regards,

    Wearsky

    • peyton's avatar
      peyton
      Regular Visitor

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