Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Need a help on Ranking with Multiple Banks and multiple quarters

Hi Team,

 

I am new to this power BI, I have a request where they are looking for a ranking chart which has multiple banks (20+ Banks) and multiple quarters (3 Years of Quarters selection).

 

What is the best way to provide the ranking charts... which they can use it for comparing for each bank for quarter better way.. any custom visuals which good for Ranking Chart please suggest.

 

Any help with this solution is greatly appreciated.

 

BankDate Value  Quarter 
Bank31/2/19 12:00 AM12,501,151.251
Bank31/2/19 12:00 AM12,454,331.361
Bank121/2/19 12:00 AM73,578,103.161
Bank121/2/19 12:00 AM73,624,072.831
Bank91/2/19 12:00 AM62,992,500.001
Bank91/2/19 12:00 AM63,065,450.001
Bank31/2/19 12:00 AM170,237,400.001
Bank31/2/19 12:00 AM170,588,700.001
Bank121/2/19 12:00 AM1,484,466.911
Bank104/1/19 12:00 AM5,231,767.852
Bank104/1/19 12:00 AM5,235,370.702
Bank104/1/19 12:00 AM2,209,822.662
Bank104/1/19 12:00 AM2,213,131.782
Bank84/2/19 12:00 AM52,066,721.172
Bank84/2/19 12:00 AM52,154,441.532
Bank74/2/19 12:00 AM781,201.872
Bank74/2/19 12:00 AM781,731.932
Bank64/2/19 12:00 AM1,236,427.992
Bank64/2/19 12:00 AM1,210,678.672
Bank84/2/19 12:00 AM89,459,680.002
Bank84/2/19 12:00 AM89,626,024.002
Bank107/1/19 12:00 AM1,118,486.913
Bank107/1/19 12:00 AM1,120,069.183
Bank17/1/19 12:00 AM16,943,550.003
Bank17/1/19 12:00 AM16,974,822.003
Bank37/2/19 12:00 AM10,000,000.003
Bank17/2/19 12:00 AM47,800,000.003
Bank17/2/19 12:00 AM47,800,000.003
Bank127/2/19 12:00 AM262,222.053
Bank127/2/19 12:00 AM261,271.313
Bank127/2/19 12:00 AM885,197.033
Bank127/2/19 12:00 AM874,734.823
Bank37/3/19 12:00 AM8,855,892.493
Bank37/3/19 12:00 AM8,858,958.733
Bank27/3/19 12:00 AM5,591,408.003
Bank77/3/19 12:00 AM3,524,437.963
Bank77/3/19 12:00 AM3,842,922.333
Bank210/1/19 12:00 AM5,061,092.454
Bank210/1/19 12:00 AM5,069,320.424
Bank210/1/19 12:00 AM2,585,325.064
Bank210/1/19 12:00 AM2,588,771.864
Bank210/1/19 12:00 AM87,465,528.004
Bank210/1/19 12:00 AM87,635,200.004
Bank110/1/19 12:00 AM55,108,332.004
Bank110/1/19 12:00 AM55,166,998.504
Bank710/1/19 12:00 AM2,929,321.334
Bank710/1/19 12:00 AM2,935,227.414
Bank910/2/19 12:00 AM10,000,000.004
Bank210/2/19 12:00 AM26,293,177.344
Bank210/2/19 12:00 AM26,301,728.934
Bank410/3/19 12:00 AM1,600,000.004
Bank1210/3/19 12:00 AM30,991,250.004
Need Help

9 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    We can try to use a Bulid-in Funnel, it will show the value based on the desc order, then we can use a slicer to spefic the quarter.

     

     


    If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that you have shared.

     


    Best regards,

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for your time for help.

       

      yes, this looks fine when you need to compare against only one quarter with all the banks.

       

      However, the request is to compare multiple banks against multiple quarters. is it possible?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Any help please?