Forum Discussion

BobWong1's avatar
BobWong1
Icon for Helper II rankHelper 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
    Icon for Community Champion rankCommunity 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
      Icon for Helper II rankHelper 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,