Forum Discussion

alextarki's avatar
alextarki
Helper I
6 years ago
Solved

Dynamic TOP N list

HI   I have investigated multiple demos and didnt find the answer for the following question : Top N - How to enter dynamicly select the list of the first N records as the filter  TOPN is hardcode...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi alextarki ,

     

    >>The filter should be by company rather then by sales measure 

     

    Do you mean to show the data of the top n companies. And you need to add an index column for it:

    Create a topn table for slicer:

    Create a measure for filter on the visual:

     

    Measure =

VAR N =

    IF ( HASONEVALUE ( 'TopN'[top] ), SELECTEDVALUE ( 'TopN'[top] ), 3 )

RETURN

    IF ( MAX ( SALES[Index] ) < N, 1, 0 )

     

     

    For more details ,please refer to https://community.powerbi.com/t5/Desktop/Dynamic-TopN-reports-in-Power-BI/td-p/122091

    Best Regards,

    Dedmon Dai

  • alextarki's avatar
    alextarki
    Helper I
    6 years ago

    Unfortunately, this topic is not related to my point I need dynamic list of value : I select TOP 10 it shows 10 records ,

    I select TOP 20 - it shows 20 records