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).   Wha...
Need Help
v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity 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?

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

        Hi Anonymous ,

         

        Sorry for delay in our response, Do you want to have multi chart for each quarter of year or compare them inside one chart with value of all quarters?


        Best regards,