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.
My report shows a summary of all staff performance to target. The Completion Rate is the total performance (sum of all completions) to the target (there are no individually based targets). I have visuals that break this down by the person, but the Completion Rate is an overall figure. Is there a way to make it so if anything is selected in the people slicer, the Completion Rate card visual shows "N/A?" Currently, it takes the person's completed and divides by the overall target, which ends up showing a very low, inaccurate percentage Completion Rate. This number is throwing people off so I put a note there, but was wondering if I can just make it show nothing or "N/A" if any person is selected in the slicer.
Solved! Go to Solution.
Use
Okay this almost exactly what I need, but if they select more than 1 person, is there a way to do this same thing?
Use
If the people column has only one filter applied at anytime(selecting specific person(s)), I would use the following:
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |