The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to Solution.
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
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