Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
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!
Solved! Go to 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
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
@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/
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.
@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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |