cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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

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
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

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.

Top Solution Authors
Top Kudoed Authors