Slicer Date Interaction with Line Chart

[kyle_hermann]

I have this line chart below, all my data is correctly presented with data from Jan 1 to today:

However, when I change the slicer to February 1, I get the graph below:

It's because of the date filter for the line chart in the picture shown below. I have January selected, so January continues to be displayed on my line graph as 100% yellow line.

If I select all the dates, or none of the dates, I am left with:

I was wondering if it would be possible to hide dates that are not selected with the slicer. The slicer is interacting with other elements on the page so it isn't really ideal or realistic to show the year to date at all times.

[Cmcmahan]

That's not January data showing at 100%.  That's Blank data, where there is no month.

You can probably fix this by setting a visual level filter with advanced filtering set so that [month] is not (Blank).

This seems likely to be caused by whatever measure you're using to determine the value of the yellow line.  If you can show us that expression, we should be able to fix this without monkeying about with visual level filters.

[kyle_hermann]

It's 100% January in the middle visual, that's because I have January selected in the visual level filter, but the slicer (not shown) starts at 2/1. It's Blank in the 3rd because I set the slicer back to 1/1 and selected all months.

I agree it seems to be in that yellow line, i will see if i can post anything helpful, I'm not the best at power bi and i didn't make these measures so let me see what i can provide

[Cmcmahan]

You should be able to check the Values section of the Fields tab, to the right of the report.  One of them should be the field used to create the yellow line. 

For example, to figure out how Increased or Decreased is determined, I clicked the visual, and found the corresponding calculated column. 


Then at the top, it displayed the expression:

If you can share that expression, we can figure out why it gives a value of 100% when there's no data.

[kyle_hermann · Accepted solution]

I figured it out. Thanks for pointing out it would be in the formula and not the visual filters.

The "1 - Expression" was what was throwing the months off, since the formula had no data to subtract in July, Aug, etc... the expression was resulting in 1 or 100%.

I had to create another expression for the yellow line and now the slicer seems to be affecting the line chart the way I would like it to.

[kyle_hermann]

So it would have to be because it's doing "1 - 0 = 100%" as in the expression below. It's got nothing to subtract from 1 July - December.

Other Non-Compliance *yellow line* = 1 - ([Rank non-Compliance *blue line*]+[RDD non-Compliance *dark blue line*])