Forum Discussion
How to process multiple selections from a slicer?
- 2 years ago
Hi Anonymous
If i understood you correctly you are trying to catch 2 values from the slicer , you can use min for lowest selection,
max for highest.For example, with the simple list, it looks like :
your formula will look something like :Measure =
VAR metric_min = min('Chosen Values'[ID])Var metric_max = max(Chosen Values'[ID])...if i missed somethingPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- 2 years ago
Hi Anonymous ,
Try the following code:
YOY difference CF = VAR _aantalmaanden = COUNTROWS( ALL('Date'[Month Name Short], 'Date'[Month]) ) VAR _metric = SELECTEDVALUE('Top 3'[Num]) VAR colorall= SWITCH( TRUE, [RANK YOY difference] <= 3 && [YOY difference %] > 0 , "Green", -- Top 3 Increases [RANK YOY difference] > _aantalmaanden - 3 && [YOY difference %] < 0, "Blue", -- Top 3 Decreases "Light Grey" ) VAR _color = SWITCH( TRUE, _metric = 1 && [RANK YOY difference] <= 3 && [YOY difference %] > 0 , "Green", -- Top 3 Increases _metric = 2 && [RANK YOY difference] > _aantalmaanden - 3 && [YOY difference %] < 0, "Blue", -- Top 3 Decreases "Light Grey" ) RETURN IF(COUNTROWS('Top 3') = 1, _color, colorall)
Anonymous @I get that but my question is if there is no negative or if there is no positive.
if there is no negative then you will not get bottom 3 and if there is no positive then you will never get top 3.
Maybe this is whet you want, as I said I am just curious to know.
- Anonymous2 years agoNot applicable
you are right parry2k