Forum Discussion

BobWong1's avatar
BobWong1
Helper II
2 years ago
Solved

Top N function does not work in the Filter Pane?

I tried to use the Top N filter function in Filter Pane as shown;

When I tried to drag a field/measure into the <<By Value>> well of 'Add data fields here', in my case I can't, why?

Is it Power BI Desktop having a problem in this area or is there a limitation of type of fields/measure that I could use?

 

  • BobWong1 

    you can use measure with TOPN, as shown below.

    can you share the measure you are trying to use with the TOPN ? 

     

    best regards

2 Replies

  • Daniel29195's avatar
    Daniel29195
    Community Champion

    BobWong1 

    you can use measure with TOPN, as shown below.

    can you share the measure you are trying to use with the TOPN ? 

     

    best regards

    • BobWong1's avatar
      BobWong1
      Helper II

      Dear Daniel,

      I managed resolved this issue after I restart Power BI Desktop. It seems to me at certain condition, it may not work. Nevertheless, I should close this issue aa accepted solution. Thanks anyway for your kind reply.

      BR,