Dynamically Changing Graph Data Based on Matrix Selections

[KadinS]

Hi all! I'm trying to dynamically choose what data is showing in graphs, with a pre-set details. For example, if I have a data set like this:

I want to be able to select a category value from a matrix, and have that filter a pie chart (for example). However, where it gets tricky is that I want the pie chart to (by default) be filtered to a pre-determined category already. For instance:

• When nothing in the matrix is selected, the pie chart only shows rows with the Alpha category. 
• When Alpha is selected in the matrix, the pie chart shows rows with the Alpha category.
• When Beta is selected in the matrix, the pie chart shows rows with the Beta category.
• When Delta is selected in the matrix, the pie chart shows rows with the Delta category.

My work so far is available in this file: Example. I've created two measures which allow me to determine which category is selected (_SelectedCategory), and another that I was trying to use as a filter for the graph (_PieGraphFilter). Unfortunately, I've had no luck and have hit a bit of a wall.

Any advice on how to approach this problem would be greatly appreciated. Thanks in advance!

[v-lili6-msft · Accepted solution]

Hello @KadinS

For your case, the category must come from two matrix and pie chart tables

You can try this sample pbix file.

Best regards

Lin

[amitchandak]

@KadinS , is filtered and has one value that should able to help you.

A measure like this on pie visual

if(isfiltered(Table[Category]), [Measure], calculate([measure], table[Category] ="Alpha"))

Also, refer: https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[KadinS]

Hi @amitchandak, thanks for your speedy response.

I'm not sure I understand what you mean sorry. Referring to the example P.BI report, is Table[Category] meant to represent Source[Category] or Categories[Category] (where Source is the raw data, and Categories table with the unique categories [which I'm using for the Row Labels in the matrix]). And which [Measure] are you referring to?

Not sure if it's worth mentioning the Data Model I have set up as well, that simulates what's going on in my actual (non-example) report.

Thanks for your time.

[amitchandak]

@KadinS , I have not seen your file yet. Somehow did not notice the link for the first time. The solution is based on the assumption that table and pie has a common category which is used and we want to filter that