Question

How can I create a multi-row card that dynamically adjusts based on the number of selected values?
I need a multi-row card in Power BI that expands or contracts based on the number of selected values from a slicer. The card should dynamically adjust to display only the relevant information without unnecessary blank spaces. What is the best way to implement this using DAX or visual-level filters?

Answer 1

To create a multi-row card in Power BI that dynamically adjusts based on the number of selected values, follow these steps:

1. Use a Measure to Count Selected Values

Create a DAX measure to count the number of selected values:

SelectedCount = COUNTROWS(VALUES(YourTable[Category]))  

2. Apply a Visual-Level Filter

• Add the multi-row card visual and place the required field inside it.
• Apply a visual-level filter to show data only when SelectedCount > 0.

3. Use a Dynamic Title or Message

• To prevent blank spaces, create a message when no selection is made:

DisplayMessage =  
IF([SelectedCount] = 0, "No values selected", CONCATENATEX(VALUES(YourTable[Category]), YourTable[Category], ", "))

• Add this measure as a title or card to improve user experience.