Card Visualization shows the wrong information

[Qianru221]

Hi All

I plotted a graph showing price changes of the company products against time.

I added one product filter.

I also added a Card visual, which shows the product name when one of the products in the product filter is selected. (I used it as the title of the graph so that the reader knows the price change against time belongs to which product.)

However the problem now is that when no product is selected in the filter, the Card always shows the 1st product, which is obviously wrong. The price changes is then the average price of all the product.

Would it be possible to make the card to show blank when no product is selected in the filter and shows the product name when one product is chosen?

Thank you in advance.  

[Zubair_Muhammad · Accepted solution]

Hi @Qianru221

Try this MEASURE

=
IF ( ISFILTERED ( TableName[Product] ), SELECTEDVALUE ( TableName[Product] ) )

[JoHo_BI · Accepted solution]

Hi Qianru, 

You'll need to use a measure here, and a formula like the following:

Selected Product = IF(HASONEVALUE(Table[Product]),VALUES(Table[Product]),"Multiple Products Selected!")

Hope that helps! 

[Zubair_Muhammad · Accepted solution]

Hi @Qianru221

Try this MEASURE

=
IF ( ISFILTERED ( TableName[Product] ), SELECTEDVALUE ( TableName[Product] ) )