cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
williamjessup
Frequent Visitor

Show no data when no filters are selected

I know there are a couple similar questions, but after looking at the solutions, none of them have worked for me. 

 

I am buildling a report in which you can look someone up and see their fields of interest and fields of expertise. My data is set up with one table containing a list of individuals ('Individuals') and another table with their interests/expertise. Each person may have several interests or expertises, or none at all. 

Individual KeyIndividual Name
1001Bob Johnson
1002Sam Miller
1003John Adams

 

Individual KeyCategoryInterest/Expertise

1001

MedicineInterest
1001HotelsInterest
1001DogsExpertise
1001CatsExpertise
1002LifestyleInterest
1002WritingExpertise

 

For the actual report, I would like to show a blank table when a member is not selected, and then when a member is selected, it shows their interests and expertise:

1.PNG

 

I've tried to play around with variations on this measure:

Int-Exp Filt = CALCULATE ( IF ( ISFILTERED ( Individuals[Full Name and ID] ), 1, 0 ), ALLSELECTED ( 'Interests and Expertise'[exa_category] ))
But Power BI doesn't like having multiple values for a measure so I get an error.  I tried the measure with FIRSTNONBLANK() instead of ALLSELECTED which works except it only shows the first non blank value (duh) and not all of the values. 
 
Does anyone have any ideas for how to show no values when a specifc filter is not selected and then show several values when that filter is selected?
1 ACCEPTED SOLUTION
v-kelly-msft
Community Support
Community Support

Hi @williamjessup

 

Modify your measure as below:

 

 

Int-Exp Filt = IF ( ISFILTERED ( Individuals[Full Name and ID] )=TRUE(),MAX ( 'Interests and Expertise'[exa_category] ),BLANK())

 

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

View solution in original post

2 REPLIES 2
v-kelly-msft
Community Support
Community Support

Hi @williamjessup

 

Modify your measure as below:

 

 

Int-Exp Filt = IF ( ISFILTERED ( Individuals[Full Name and ID] )=TRUE(),MAX ( 'Interests and Expertise'[exa_category] ),BLANK())

 

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

View solution in original post

amitchandak
Super User IV
Super User IV

Refer:

https://community.powerbi.com/t5/Desktop/Show-no-data-in-a-table-until-a-slicer-item-selected/td-p/4...



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.