Reply
Frequent Visitor
Posts: 4
Registered: ‎10-19-2018

Filter a combo chart by two separate entries of one category

[ Edited ]

 

Capture2.PNG

On a line-column combo chart I'm trying to make the columns display the data of specific individuals on a team, and the lines display the average of the team. I have the a name column in the dataset with "Person 1", "Person 2", "Person 3", and "Overall Team". Is there a way to filter the lines and columns separately by this name column? 

Highlighted
Moderator
Posts: 9,894
Registered: ‎03-10-2016

Re: Filter a combo chart by two separate entries of one category

@alim94,

How about you drag the name column to Column series  of the combo chart? And to filter the Line by name, you would need to create measures. 

If you have questions about DAX, please share sample data of your table and post expected result based on sample data following the guide in this blog.


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.