Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I'd like to see within a card a comment based on selection of the slicer.
I'm not sure how go about this.
This is the slicer:
If "Selected All" or none selected then "All".
If all 0-7 in green selected then "Sub".
If only 220 selected then "High".
If there are random selections then "Multiple".
This will be for a title of a chart. I'm working with selectedvalue but with no success so far. Still going at it.
Solved! Go to Solution.
Hi,
this should do the trick:
I likely was not clear with the card expectations.
@amitchandak
@Anonymous
Here's a better example:
Slicer settings:
if none selected. Card reads "none".
if all selected. Card reads "All".
if all selected as shown. Meaning all of 0-1-2-3-4-5-6-7 are selected at the same time. Card reads "Sub".
if only "220" is selected as shown. Card reads "High".
Thanks for the attemped solutions, but none of them met the criteria or did something entirely different than intended.
I tried to play around and modify the solutions but still could not get them to work.
Still seeking help please.
@Anonymous
I commented out the line for "Multiple". I still do not know what [ct] mean. Until that is clear, I can leave that out.
As you can see, even when nothing is selected "All" does show up in the card.
Along the same lines, selecting 0-7, "Sub" does not show either on the card.
I'll play with your expression to see if I can get it to go.
Thanks for the response.
Any further help is appreciated!
Hi,
this should do the trick:
Thank you Anonymous Max. I revisted this and was able to implement your measure.
@Anonymous
Hi Max,
I do not know what [ct] means with respect to the expression. I do not have a column "ct" in my table.
Should I use an use an explicit measure to get count? Does ct = count?
Thanks.
Ron
Switch(
isblank( Selectedvalue(Table[Column])) , "All",
Selectedvalue(Table[Column]) *1 <=7, "Sub"
Selectedvalue(Table[Column]) *1 =220, "High"
//add other conditions
)
@amitchandak
Thank You for the reply.
Maybe there is somethings I am missing as it is not working for me. I created the measure and
dropped it into a card and choose the slicer settings but get the following....
Not sure what I am doing wrong.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
69 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
127 | |
32 | |
27 | |
24 | |
22 |