Filter only one field of a visual

[Anonymous]

Hi, 

I have this visual 

that I need to filter on the "status" column. 

This is ok but I want to get rid of the stacked bar for history and keep only the line. The problem is if I select only ORDER and SnOP in the slicer I lose the history line because it put aside all the raw with status=hist

How can I do so the slicer only apply on the bar chart and I keep the line for history ?

All the data here is from one table with the columns 'date', 'quantity', and 'status'

Thank you

[ppm1 · Accepted solution]

You can try this approach with two measures.

BarMeasure = CALCULATE([YourMeasure], KEEPFILTERS(Table[Status]<>"Hist"))

LineMeasure = CALCULATE([YourMeasure], Table[Status] = "Hist")

Pat 

[Anonymous]

Thank you this is almost it, 

now I have this 

BUT there is still something weird : when I select for example only ORDER in the slicer, all the values of the line are changing for some random smaller number. How is that possible since the measure only takes the rows with status=hist ??