Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Group data and nice graph

Hi! Does anyone know how to do this easily? I want to group two columns (to create kind of family) and get the result as on attached graph. Blue, green and yellow bars are XYZ and the axis shows val...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    You get the samer result by dragging columns as shown in picture below into a clustered column chart:

Anonymous's avatar
Anonymous
Not applicable
7 years ago

You get the samer result by dragging columns as shown in picture below into a clustered column chart:

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    Anonymous wrote:

    You get the samer result by dragging columns as shown in picture below into a clustered column chart:

     

    Im soooo stupid :) thanks man!

     

    Do you know though how to re-change the order in graph? Mine is D A C B...

    • Ani1991's avatar
      Ani1991
      Resolver III
      7 years ago

      Hi Anonymous 
      At the right top corner of the visual there is an ellipse (...) button. Click on it and select Sort by the column name that you used as X axis and then do sort by ascending.

       

      Thanks,

      Ani

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Thank you Ani1991 and Anonymous  so much for the replies! I am still learning PowerBI and I am quite new on it... 

         

        Other question... is there a way to put in the "matrix" visual filtering like in Excell columns? So to have it on top so anyone can play with filtering?

        Could you also suggest much nicer graph than the Clustered Column Chart? It doesn't look visually very nice. I am looking for something more interesting...