cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jowilli
Regular Visitor

Show no data in a table until a slicer item selected

I have a report that shows projected parts issued based on forecasts. In the report, I have a slicer that allows the report consumer to select the Planning Center(s) that they want to see the forecasts for. They can select multiple Planning Centers. I have a second table that I use to show the Planning Center Descriptions that have been selected (the slicer is a long list that doesn't all apprear on the screen). If nothing has been selected in the slicer, the entire list of Planning Centers appears in the table of planning center descriptions. I would like this table to be blank until something is selected in the slicer.

Can someone tell me how to do that?

1 ACCEPTED SOLUTION
Greg_Deckler
Super User IV
Super User IV

Sample data always helps...Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

That being said, try adding a hidden column measure like this:

 

Measure = IF(COUNTROWS(ALLSELECTED((Table))) = COUNTROWS(ALL(Table)),BLANK(),1)

Will return blank when nothing is selected, otherwise returns a value. Blanks will not show up in your table so the table will be blank until something is selected. Hide the measure column by turning off word wrapping and shrinking the column until it it doesn't show.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
Greg_Deckler
Super User IV
Super User IV

Sample data always helps...Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

That being said, try adding a hidden column measure like this:

 

Measure = IF(COUNTROWS(ALLSELECTED((Table))) = COUNTROWS(ALL(Table)),BLANK(),1)

Will return blank when nothing is selected, otherwise returns a value. Blanks will not show up in your table so the table will be blank until something is selected. Hide the measure column by turning off word wrapping and shrinking the column until it it doesn't show.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors