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
mattlee
on:
“Add Value” in Textbox Not Visible in Dark Theme
on:
Bi Crashes on launch with (AS Process PID=XXXXXX H...
on:
Fix the Date function in DAX
on:
May 25 update for Snowflake Connector v2 has broke...
on:
Unable to open existing PBIP files