topic Re: Manipulate Chart Display from Matrix in Custom Visuals Development Discussion

Manipulate Chart Display from Matrix

RPYee — Wed, 28 Feb 2024 18:45:58 GMT

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:

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

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

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!

Re: Manipulate Chart Display from Matrix

lbendlin — Thu, 29 Feb 2024 01:04:28 GMT

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

Re: Manipulate Chart Display from Matrix

RPYee — Tue, 05 Mar 2024 12:30:21 GMT

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!!