Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
Thank you so much, you made my day!
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!
@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
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.