Forum Discussion
Anonymous
2 years agoNot applicable
Top N slicer define issues
Hi all - i am following the instructions here https://blog.magnetismsolutions.com/blog/colinmaitland/2022/05/13/how-to-configure-a-top-x-slicer-in-power-bi I am having some issues at the step 2...
toziu
2 years agoRegular Visitor
the first problem is simple.
selectedvalues([value],100) means that if Values are not unique,if will return 100, now you don't filter your [value],so it's value is from 1 to 100, so the function will return 100
You should put [value] in the slicer, here i choose 5, [value] has only one value,
so the selectvalue() will return 5,not 100
and the rank <=5,will return 1 ,just likes the picture.
can i see your all function?now i can't know the answer of your second question.