Forum Discussion
Card value corresponding to slicer value
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?
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.
2 Replies
- amitchandak
Super User
Anonymous , sum(Table[Score]) as measure should give that ?
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.
