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

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

      Hi Anonymous ,

       

      How about  try to use the build in treemap visual? It will show quarter with different color, then draw size for each bank based on the value.

       

       


      Best regards,

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thank you, but this will not give the ranking unless we hover the mouse right? 

         

        I may not be able to compare with multiple banks' at a time that again a challenge here.