cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
alim94 Frequent Visitor
Frequent Visitor

Filter a combo chart by two separate entries of one category

 

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? 

1 REPLY 1
Moderator v-yuezhe-msft
Moderator

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.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 6 members 2,979 guests
Please welcome our newest community members: