Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
@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
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
108 | |
96 | |
95 | |
74 | |
71 |