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
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