line and column chart, apply filter to column only

[Jay74]

Hi,

I have a series of data 2 columns in particular, showing status of an item - Open or overdue for different vendors.  I'd like to do a combined line/column chart and filter the colum showing overdue only while the line shows total count (open + past due) per vendor, so the overdues can be shown in context to the total.  Whenn I do the chart and apply a filter for overdue, it filters the column and the line.  any thoughts how I can filter column only?

Thanks

[bcdobbs · Accepted solution]

You'd have to write a measure to use on the column using CALCULATE to add a filter directly. For example

CALCULATE (
   COUNTROWS ( Item ),
   Item[Status] = "Overdue"
)

 Obviously you'll have to adjust code to your model.

You can then use that as the value for your bar and another measure or the auto measure for the line.

[jeroendekk · Accepted solution]

Hi @Jay74 
For the total one (the one ignoring the filter) you could create a CALCULATE measure with REMOVEFILTER, or the other one you could create a CALCULATE measure that includes the overdue filter. I cannot be more precise without a sample of the data.
But the awnser is a measure with CALCULATE.

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

Best regards,
Jeroen

[bcdobbs · Accepted solution]

You'd have to write a measure to use on the column using CALCULATE to add a filter directly. For example

CALCULATE (
   COUNTROWS ( Item ),
   Item[Status] = "Overdue"
)

 Obviously you'll have to adjust code to your model.

You can then use that as the value for your bar and another measure or the auto measure for the line.