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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

 

 

Any reason it's still showing like this...Thanks!

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
    )

     

  • toziu's avatar
    toziu
    Regular Visitor
    2 years ago

    i can't find the mistake,maybe you can send a private message to me

    with your all tables and functions.