Line disappearing from line & column chart depending on (seemingly) unrelated filter selection

[Tubbyland]

Hi folks,

My data set includes utility usage and GHG emission data for several different organizations. I have a line and stacked column chart that works great for most organizations, but when I select one particular org, the line disappears. The thing is, the line data is constant and doesn't depend on the filter selections.

The only thing changing in the images below is the filter on "Member Name". The "HDD - Ontario" line is visible for one but not the other, even though the data does not change.

What am I missing?
Thanks!

no lineline works

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.  Show the problem there very clearly.

[HoangHugo]

Hi

Try to use secondary axis for your line chart

Can you share your fomular of line chart, I see it up-down by month axis, but it is constant? right?

[Tubbyland · Accepted solution]

Aha! I had turned on bi-directional filtering: the member was filtering the dates. Problem solved!