Forum Discussion

Pragati's avatar
Pragati
Frequent Visitor
9 years ago

top 11 to 20

Hi, In my Pie chart I have selected Top 20 based on Count of UOM. What do I do to display top 11 to 20 values in my pie chart( i.e. from HKG to POL).
Need Help
Show and Tell
Tips and Tricks
Arfaa's avatar
Arfaa
New Member
9 years ago

I had a similar query. Let me know if you get a solution

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Pragati

     

    Hi, use this Measure in Values Section of your visual (mantaining the top 20 filter)

     

    SalesFiltered11to20 =
IF (
    COUNTROWS (
        INTERSECT (
            VALUES ( Table1[Code] ),
            TOPN ( 10; ALL ( Table1[Code] ), CALCULATE ( SUM ( Table1[Sale] ) ) )
        )
    )
        > 0,
    BLANK (),
    SUM ( Table1[Sale] )
)

      

    • Pragati's avatar
      Pragati
      Frequent Visitor
      9 years ago

       

      Thank you for your response.

      It is not giving me the desired output. I wanted Top 11-20 values.

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi Pragati,

        You can create a new table display the top 11-top20 values, then use the new table to create visual as follows.

        1. Create a new table using the formula.

         

         

        NewTable = INTERSECT(TOPN(10,SUMMARIZE(Table,Table[Access Country],"Count of UON",COUNTA(Table[UOM]),"%GT Qty",[%GT Qty]),[Count of UOM]),TOPN(20,SUMMARIZE(Table,Table[Access Country],"Count of UON",COUNTA(Table[UOM]),"%GT Qty",[%GT Qty]),[Count of UOM]))


        2. Create a pie chart use the 'NewTable', select the [Access Country] as Legend, the [%GT Qty] as value, please check if it works fine.

        If this still resolves your issue, please share your sample table, or .pbix file for further analysis.

        Best Regards,
        Angelia