Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |