Forum Discussion
Disable the visual on filtering the data row less than 10
Hi Community,
I'm looking for a solution to disable the table visual when filtering the data to less than 10 rows.
Thanks in advance for your help.
3 Replies
Uzi2019Community Champion
Hi Anonymous
Please explain your query with screenshot if possible. It better for us to understand your requirement.Hi Uzi2019 ,
So I have confidential dataset, where I want the client to see the based on the sample selection of more than 10. If the user is filtering data which has less than 10 rows must give them blank visual.
Sample data:Name Email Gender Project ABC [email protected] M A CDE [email protected] F B EFG [email protected] M C FGH [email protected] F D GHI [email protected] F E ABC [email protected] M B CDE [email protected] F C EFG [email protected] M D FGH [email protected] F E GHI [email protected] F A ABC [email protected] M C CDE [email protected] F D EFG [email protected] M E FGH [email protected] F A GHI [email protected] F B Hi, Anonymous
Power BI doesn't currently support conditional visibility of visuals directly based on the number of rows returned by a filter. Visuals in Power BI aren't dynamically hidden or visible based on the data they contain. However, you can consider using other methods to achieve similar results.
You can create two versions of a report page - one with a tabular visual and one without a tabular visual. Then, use bookmarks to capture the status of each page and use buttons to navigate between those bookmarks.
You can check the following link:
Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn
If a table visual with fewer than 10 rows doesn't make sense, consider adding a text box to your report to explain this so that users can understand why they might not always want to filter to such a small dataset
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.