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.
Good day.
I have two slicers, Region and Zone. Region is the highest level to Zone i.e. 1 region has multiple zones. Currently, I can display either the selected region or the zone on my card visual, which is perfect.
But if both are selected at the same time, I need to display the lowest level only which isthe zone. Is there a way to do this?
Dax for the measure:
Thank you in advance.
Solved! Go to Solution.
Hi @Tlotly
I think you can change the order of the IF statement slightly to make this work as you want
Measure 3 = var _region = SELECTEDVALUE(Query1[Region Description])
var _zone = SELECTEDVALUE(Query1[Zone Description])
var _branch = SELECTEDVALUE(Query1[Branch Name])
return if(ISFILTERED(Query1[Zone Description]), _zone,
if(ISFILTERED(Query1[Region Description]), _region,
if(ISFILTERED(Query1[Branch Name]), _branch
," ")))
This way it will check if a zone has been selected first, and if so display the selected zone.
Hi @Tlotly
I think you can change the order of the IF statement slightly to make this work as you want
Measure 3 = var _region = SELECTEDVALUE(Query1[Region Description])
var _zone = SELECTEDVALUE(Query1[Zone Description])
var _branch = SELECTEDVALUE(Query1[Branch Name])
return if(ISFILTERED(Query1[Zone Description]), _zone,
if(ISFILTERED(Query1[Region Description]), _region,
if(ISFILTERED(Query1[Branch Name]), _branch
," ")))
This way it will check if a zone has been selected first, and if so display the selected zone.
User | Count |
---|---|
77 | |
77 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |