Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
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.
@Anonymous , sum(Table[Score]) as measure should give that ?