Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |