Forum Discussion

paresh's avatar
paresh
Frequent Visitor
10 years ago

Getting TOP n Items in a Table/chart

I have gone through the forum and have found many queries which pertain to the above topic (have searched on TopN and RankX). I have tried all of them and have not been able to come up with the corre...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi paresh,

Regarding to the issue that how to display data properly in Box and whisker chart, please directly contact the author. In this link, you can send an email to the author by clicking “Contact Author” as shown in the following screenshot.

 

Thanks,
Lydia Zhang

paresh's avatar
paresh
Frequent Visitor
10 years ago

Thanks Lydia.

However, I dont think it is an issue with this specific visualization. If I am able to get the correct data in a Table visualization, it will also show correctly in the Box and Whisker chart.

 

So I feel, it is primarily to do with formulating the correct expressions to get the correct values. Rest will all fall in place.

  • paresh's avatar
    paresh
    Frequent Visitor
    10 years ago

    I have tried to make some data in Excel and linked that to a PowerPivot (I have never worked in PowerPivot and will finally want my results in PowerBI, but just to simplify things)

    The excel Sheet can be downloaded from this Link

     

    I have also explained in the 2nd sheet what I want.

  • paresh's avatar
    paresh
    Frequent Visitor
    10 years ago

    I will try and explain my problem a litte more.

    I want to pick my Top 3 items and then graph them.

    So the RankX measure has been defined.

     

    If I select my month Filter as 1, I get the following results

     

     

    So Coke is at Rank 4 and Pepsi is at 1

    If I change the Month to 2

     

    Now for this month, Coke moves to the 2nd position.

     

    However If I select both the months, I want a consolidated ranking of my items. Whereas I get the rankings monthwise

     

    In the output that I want, the Rank column for the same item should be the same. The ranking for Coke should be 2, Fanta 4, Pepsi 1 and Sprite 3