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,
I would like to know how to go about adding a card that would change depending on the single selection on the slicer?
For example: If Apple is selected in the slicer - this card would say FRUIT.
Seems to be very simple but I'm so new to Power BI.
Thank you,
Solved! Go to Solution.
If you have the selectable items used in slicer in Table[Column]:
MeasureToUseInCard=
SWITCH(SELECTEDVALUE('Table'[Column]),
"Apple", "Fruit",
"Banana, "Fruit",
"Iphone", "Phone",
"No value selected" )
The next step could be to store the values to show in the table as well:
MeasureToUseInCard =
SELECTEDVALUE('Table'[Group], "No value selected)
Best Regards // Ulf
If you have the selectable items used in slicer in Table[Column]:
MeasureToUseInCard=
SWITCH(SELECTEDVALUE('Table'[Column]),
"Apple", "Fruit",
"Banana, "Fruit",
"Iphone", "Phone",
"No value selected" )
The next step could be to store the values to show in the table as well:
MeasureToUseInCard =
SELECTEDVALUE('Table'[Group], "No value selected)
Best Regards // Ulf
Thanks a lot! @Anonymous I will use this for some of my other cards. For some reason, when I filtered through my slicers, the right equivalent text showed up on the card.
Patrick
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 |
---|---|
107 | |
97 | |
75 | |
63 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |