Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |