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.
I have a simple measure
m1: Calculate(FactTable, [solved]=true())
m2 Calculate(FactTable, [solved]=false())
In the same table I have a column (teacher) which is also either true or false. If you have 1-6 where Solved is true, the first and last 3 have true in teacher.
If I put both measures on a piechart it works fine.
If I click the true part in the pie chart for teacher, the pie chart for Solved changes fine.
However if click on the true part of the solved pie chart, the teacher pie chart won't change to reflect this filter.
I have tried countax(filter(factTable, solved=true(),true);
as well, I have tried with allselected,values and all, but I can't get this filter function to work.
Any ideas or solutions?
Solved! Go to Solution.
Alright, a little update.
I made it work.
All I had to do was put the [solved] column into the "Legend" part of the visual.
The only problem this gives is that I couldn't give the legend the name I wanted (solved, not solved) but was instead shown as "true" or "false". Changing the data labels so I showed percentage and category name was a solution though.
Alright, a little update.
I made it work.
All I had to do was put the [solved] column into the "Legend" part of the visual.
The only problem this gives is that I couldn't give the legend the name I wanted (solved, not solved) but was instead shown as "true" or "false". Changing the data labels so I showed percentage and category name was a solution though.
Hi AndersMadsen,
"However if click on the true part of the solved pie chart, the teacher pie chart won't change to reflect this filter."
<-- Could you please clarify more details about the issue of your filter?
If possible, can you post some dummy data and measures you are using for further analysis?
Regards,
Jimmy Tao
to the top
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |