Forum Discussion

marijane's avatar
marijane
Icon for Helper I rankHelper I
5 years ago
Solved

limit TOPN

Hi  everyone,   I want the top ten products by value so I filter the top N 10 on visual  and the table only shows the ten products by value which is right. The problem is when I add columns to the ...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi marijane ,

     

    Is this the problem?

    Please refer to my .pbix file.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi marijane ,

 

How about doing like this?

If it's helpless, please show me your .pbix file or sample data.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

marijane's avatar
marijane
Icon for Helper I rankHelper I
5 years ago

The problem is that there is a repetition in many columns that's why it is adding more rows. I send you a sample.  In this case, I want the Top 2 but there are 3 rows instead of 2 (because of the repetition of one column).

 

Thank you in advance 🙂