Card Visual: Leave blank instead of showing First or Last?

[ericdpalmer]

I have a card visual that is displaying a text field (Status Summary) so that when a user selects a row from a table visual above the card it will display the status message associated with the selected row/record from the table.

When a row from the table is not selected it appears my only option is to display the first or last record from the data set (based on the Visualization->Fields settings).

Is there a way to leave the card blank unless an individual record/row is selected from the table visualization?

[v-zhangti · Accepted solution]

Hi, @ericdpalmer 

You can try the following methods.
Sample data:

Measure = IF(SELECTEDVALUE('Table'[Index])<>BLANK(),SELECTEDVALUE('Table'[Type]),BLANK())

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ericdpalmer]

Apologies for the delayed response, I will certainly give this a shot!  Thank you!

[Ashish_Mathur]

Hi,

This may be possible with a measure.  Share the download link of the PBI file.

[BI_Climber]

Hello Eric,

I ran into the same issue a couple of weeks ago.

A workaround that fixed this for me was to add an empty row into the dataset which the graph connects to.

If you then set the table to display the first record from the data set, it will display the empty row you just added.

With this, your card visual should stay empty when nothing is selected and change to the corresponding row in the dataset when you do select something.

Hope this helps.