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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I would suggest that you play around with the different visualisations and settings for them, here i copied the first viz and changed som settings:

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I just don't get it why the new microsoft tool has such a poor graph visuals... Excell has 3d and other stuff...