Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
mtp03
Frequent Visitor

Show N/A on Card visual when slicer is selected

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.

1 ACCEPTED SOLUTION

Use 

Measure = IF(
ISFILTERED(PersonColumn),
BLANK(),
SUM(CompletionColumn)
)

View solution in original post

3 REPLIES 3
mtp03
Frequent Visitor

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 

Measure = IF(
ISFILTERED(PersonColumn),
BLANK(),
SUM(CompletionColumn)
)
pbi-novice
Helper I
Helper I

If the people column has only one filter applied at anytime(selecting specific person(s)), I would use the following:

Measure = IF(
HASONEFILTER(PersonColumn),
BLANK(),
SUM(CompletionColumn)
)
 
And use that measure in place of the "CompletionColumn". You can also replace Blank() with any string such as "N/A".

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.