Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
Need Help
toziu's avatar
toziu
Regular Visitor
2 years ago

i have tried this ,it work well.In slicer , i choose [value]=30,so the selectedvalue() in the card also shows 30

try to Put rank[value] and selected rank in the matrix.if your function is right,it would be the same as the [value],just like the picture.

 

maybe you should show me all of your table and your function.

the picture you replied i think is right. 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Sorry for any confusions. 

 

 

Rank (renamed as value) = GENERATESERIES(10,100,5)
Selected Rank = SELECTEDVALUE('Rank'[Value],100)

 

is selected customer rank (exposure) = 
VAR _borrower_rank = [Borrower Revenue]
VAR _selected_rank = 'Rank'[Selected Rank]
RETURN
    IF (
        AND ( NOT ISBLANK ( _borrower_rank ), NOT ISBLANK ( _selected_rank ) ),
        IF ( _borrower_rank <= _selected_rank, 1, 0 ),
        0
    )