Hide table if value is not selected in any of the slicer

[Anonymous]

Hi All, 

I have 2 questions

1) I have 4-5 slicers and 1 table. By default if none of the values are selected in any of the slicers then table should not display any records. 

Need to show records only if the values in slicers have been filtered. 

2)Also can we restrict that table to show only if the number of records filtered less than 1000 records? 

Thanks

Prakash

[ashlibek]

Thank you so much, you made my day!

[v-kelly-msft]

Hi  @Anonymous ,

Is your issue solved now?

What suggested by @amitchandak  should be a good solution,if not,pls provide some data.

Best Regards,
Kelly

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

[amitchandak]

@Anonymous , for the first one you can use isfiltered .

example final YTD = if(isfiltered(Date[Month Year]) || isfiltered(Date[Year]) || isfiltered(Date[Date]),[YTD Sales 1],[YTD Sales])

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

for the second one you need use rank or TOPN at visual level,

[Anonymous · Accepted solution]

@Anonymous 

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.

And check this blog by Matt- https://insights.votivasoft.com/show-or-hide-a-power-bi-visual-based-on-selection/

Appreciate your kudos!! Mark my post as solution if this helps.