Forum Discussion
Table Row Selection & Interaction with Other Visuals
Good morning! Question for you all. Is there a way to change what is shown in a visual if nothing is selected in a table? I have a report with a table listing a bunch of projects. When you select a row (a project) in the table, information is displayed in a couple multi-row cards just below the table. I'd like the multi-row cards to show something like "Please select a project above" if no row is selected in the table. Is there a way to do that? I attached a screenshot of the report below. Any help would be much appreciated! Thanks!
Hi jyeager,
Rather than directly place related fields into multi-row cards, please add below measures into cards.
Color value = IF(ISFILTERED('Sample Table'[Project]),SELECTEDVALUE('Sample Table'[Color]),"Please select a project above") Location value = IF(ISFILTERED('Sample Table'[Project]),SELECTEDVALUE('Sample Table'[Location]),"Please select a project above")Best regards,
Yuliana Gu
1 Reply
- v-yulgu-msftMicrosoft Employee
Hi jyeager,
Rather than directly place related fields into multi-row cards, please add below measures into cards.
Color value = IF(ISFILTERED('Sample Table'[Project]),SELECTEDVALUE('Sample Table'[Color]),"Please select a project above") Location value = IF(ISFILTERED('Sample Table'[Project]),SELECTEDVALUE('Sample Table'[Location]),"Please select a project above")Best regards,
Yuliana Gu