Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Dear team,
I would like to show/hide the visuals based on the slicer count. If the slicer selection is more than 1 then I would like to display the table which has the main column the same as a slicer. If the selection is 1 then another table of visual data should be displayed in it.
Example:
I have a country as a slicer. If more than one country has been selected then the country table visual should display the data. If only one country is selected then the product table visual should display the data. I have created a measure SelectionCount.
SelectionCount = COUNTROWS(VALUES(table[COUNTRY]))
When I used the card element to verify the selection it displayed the expected result. If I applied the same on the visual filters like the product table visuals show the data SelectionCount is 1. It is working as expected the real problem happened on the visual_1 which is a country table. When I applied the visual filter like SelectionCount is greater than 1 it did not work as expected. Always hide the data. But, Visual_2 which is the product table working as expected show/hide.
When I workaround the same like the Visual_1 using Segment instead of the country then I got the expected result. Show/Hide functionality working fine.
Is there any limitation in Power BI while using the slicer attribute using any visuals then it is not working as expected. I have changed the condition SelectionCount is less than 1 or 2 then the data displayed in the table.
Could you please help me out?
Regards,
Vignesvar.A
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @vignesvar ,
Please provide a sample, or .pbix file, that maps out your data model. And show your expected results.
Best regards,
Community Support Team_ Scott Chang