Card value corresponding to slicer value

[Anonymous]

Hi everyone, 

Question: If my slicer values are the ticker, how do i make it such that if i click XXX in my slicer, i would get a corresponding score of 54.714 in my card? Thank you.

Also, does it work if i replace card with gauge?

[Anonymous · Accepted solution]

Hi  @Anonymous  ,

Here are the steps you can follow：

1. You can put the ticker and score columns directly into the table visual object, and then put the ticker column into the slicer to filter

2. If you want to select a certain field of ticker, the corresponding value will be displayed. If there is no selection, the user-defined information will be displayed

You can write a DAX function and place it in the card:

Ticket_select =
var _select=SELECTEDVALUE('Table'[Ticker])
return
IF(_select=MAX('Table'[Ticker]),MAX('Table'[Score]),BLANK())

Result：

You can downloaded PBIX file from here.

Best Regards,

Liu Yang

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

[amitchandak]

@Anonymous , sum(Table[Score]) as measure should give that ?