Forum Discussion

jyeager's avatar
jyeager
Helper I
7 years ago
Solved

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-msft's avatar
    v-yulgu-msft
    Microsoft 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