Forum Discussion
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?
- Anonymous1 year ago
3 Replies
- Ashish_MathurSuper User
Hi,
I am not sure but see if this measure works
Measure = coalesce([your measure],0)
- AnonymousNot applicable
- peytonRegular Visitor
This is exactly what I was looking for. Thank you for the solution.