Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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
v-yuezhe-msft
Employee
Employee

@Anonymous,

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
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.