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 all!
please help with the following,
I have a Geo slicer with list of regions, for the sake of this example let's use continets:
I created a Dynamic Text Box which returns selected values from a slicer,
e.g.
if Europe is selected it returns => Europe ,
if Asia and Europe is selected it returns => Asia and Europe,
if 3 or more continets are selected it returns => Asia and Europe, etc.
if all continets are selected (or none is selected) it returns => All.
the only thing I can't figure out is how to return "all but one" when one continet is deselected
e.g. => "all but Europe" when all continents except Europe is selected or other scenarios.
Solved! Go to Solution.
@Ali_Shakh , Try a measure like
Add other conditions
Switch( True() ,
countx(all(Table[Regions]), [Regions]) -1= countx(allselected(Table[Regions]), [Regions]) , "all but" & maxx(except(all(Table[Regions]), allselected(Table[Regions])), [Region]) ,
// add other conditions
)
@Ali_Shakh , Try a measure like
Add other conditions
Switch( True() ,
countx(all(Table[Regions]), [Regions]) -1= countx(allselected(Table[Regions]), [Regions]) , "all but" & maxx(except(all(Table[Regions]), allselected(Table[Regions])), [Region]) ,
// add other conditions
)
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 |
---|---|
44 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
61 | |
50 | |
45 | |
20 | |
17 |