Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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:
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
96 | |
90 | |
79 | |
67 |
User | Count |
---|---|
153 | |
125 | |
114 | |
111 | |
95 |