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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
RPYee
New Contributor

Manipulate Chart Display from Matrix

I have a matrix that interacts with a line chart next to it.  When one of the columns is selected in the matrix, the line chart reacts appropriately:

RPYee_0-1709145257758.png

However, if no columns are selected in the matrix, ALL lines are displayed in the chart:

RPYee_1-1709145337540.png

 

When there is no column selected, I'd like to see the line chart represent the results of the "Total" column:

 

RPYee_2-1709145415033.png

 

I am extremely new to PowerBI. In fact, this is my first project.  I am open to any and all suggestions on the best way to accomplish this objective.  


Thanks, in advance, for any help you can provide!

 

 

1 ACCEPTED SOLUTION
lbendlin
Esteemed Contributor III

Read about FILTERS() and HASONEVALUE().  Then read about using measures as visual filters.

View solution in original post

2 REPLIES 2
lbendlin
Esteemed Contributor III

Read about FILTERS() and HASONEVALUE().  Then read about using measures as visual filters.

RPYee
New Contributor

While I'd have liked something a bit more specific, it did point me in the right direction.  I'd have been searching forever without this help.  Thanks!!

Helpful resources

Announcements
Users online (2,586)