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,

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        One chart would help. however, if no option at all then needs to see on multi-chart.

         

        Here mainly we are looking at how the ranking changes based on the amount for each month/quarter so that it help to compare against bank.