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,
I have a multi select filter of countries.
Is there any way through which I can check another condition for the selected items individually
For Ex: Currently germany, Italy and India are selected
So, I need to get the values selected (Germany, India, Italy )and check a condition on the values individually based on the selected values
Like this condition : (value of Germany is blank or value of Italy is blank or Value of India is blank) seperately.
This condition for checking blank will b dynamically based on the selected countries in the filter.
Any help?
Solved! Go to Solution.
@v-easonf-msft Yes It is solvd. I used CONCATENX and VALUE function to get the selcted values combined in a text and then usd IFERROR and SEARCH function to chck for the selecte values using IF ELSE statements
Hi, @Anonymous
Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-easonf-msft Yes It is solvd. I used CONCATENX and VALUE function to get the selcted values combined in a text and then usd IFERROR and SEARCH function to chck for the selecte values using IF ELSE statements
Hi, @Anonymous
Try this:
Filter_Test =
VAR Filters_Limit = 5
RETURN
IF (
ISFILTERED ( 'Table'[Column1] ),
VAR ___f = FILTERS ( 'Table'[Column1] )
VAR ___f2 = EXCEPT(ALL('Table'),___f)
VAR ___t = TOPN ( Filters_Limit, ___f, 'Table'[Column1])
VAR ___t2 = TOPN ( Filters_Limit, ___f2, 'Table'[Column1])
VAR ___d = CONCATENATEX ( ___t, 'Table'[Column1], ", " )
VAR ___d2 = CONCATENATEX ( ___t2, 'Table'[Column1], ", " )
VAR ___x = "[Selected]: " & ___d
VAR ___X2 = "[Blank]: " & ___d2
RETURN ___x & UNICHAR(13) & UNICHAR(10) & ___X2
)
Result as shown below:
Mark this post as solution if this helps, thanks!
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 |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |