How to apply filters to specific data/value areas

[Dabin]

Is there a way to a filter to just one data/value field? I'm using the same data set for a column and line graph but I'd like to filter the line data and leave the column data alone. Any help would be appreciated!

[Greg_Deckler]

You would likely need to write a measure for your line value that returns BLANK except for the specific data you are looking to display.

[Dabin]

As someone who is relatively new to Power BI, could you explain how I do that and what the measure would look like? 

[Greg_Deckler]

With sample data I could be specific to your case. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

That being said, let's say you have a Category column as your X axis and in this hypothetical Category column you have values of X, Y and Z but you only want the line to show a value for Y and we will assume that you already have a measure for your line value. You would do this:

Hypothetical Measure = 
  VAR __Category = MAX('Hypothetical Table'[Hypothetical Category Column])
RETURN
  IF(__Category = "Y",[Hypothetical Line Value Measure],BLANK())

[Dabin]

Hi Greg, I really appreciate your help. I'll attach some pictures of the data that could perhaps help me explain.

Here is the graph that I'd like to fix. As you can see I'm using the exact same source/data for both the line and the columns. I'd like to filter the line so that it shows an acceptance rate of submissions while the columns show the overall submissions. I know I can do this if I'm able to apply a filter from another set of data that I have that has the catagories that need to filter out. All of the data is linked together as it's all from the same excel spreadsheet. I just want the filter that I apply to only work on the line values.

Column/Line GraphData & Filter

[Ashish_Mathur]

Hi,

What exact result are you expecting?  Show that in a simple table format.  From the table, we can build any visual we want.