Forum Discussion

BlueTiger's avatar
BlueTiger
Icon for Helper I rankHelper I
7 years ago
Solved

Please help me recreate this bar chart

I tried all Friday to make what should be a simple bar chart, but I am just not succeeding, please help me.   I want to recreate the following bar chart which I found on a YouTube video of a Power ...
Need Help
  • themistoklis's avatar
    themistoklis
    7 years ago

    BlueTiger

     

    You need to put all groupings into one field.

    You have them on separate fields.

     

    Either create a new column with the groupings using DAX formulas or do it using Power Query

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
7 years ago

BlueTiger

 

Make sure that axis and value section under Visualizations Pane have a field.

Image below

 

Axis will have the grouping

 

  • BlueTiger's avatar
    BlueTiger
    Icon for Helper I rankHelper I
    7 years ago

    Thanks,

     

    I did try that, but it just goes weird like below.

     

     

    Those values are Sums and the data I created randomly:

     

     

     

    • themistoklis's avatar
      themistoklis
      Icon for Community Champion rankCommunity Champion
      7 years ago

      BlueTiger

       

      You need to put all groupings into one field.

      You have them on separate fields.

       

      Either create a new column with the groupings using DAX formulas or do it using Power Query

      • BlueTiger's avatar
        BlueTiger
        Icon for Helper I rankHelper I
        7 years ago

        Thanks for that. I have it working now.

         

         

        I did that by creating a new sheet in excel and summarizing the data.

         

         

        The only problem is that I was hoping to be able to double click on one of the bars and be able to see a table of the clients sorted by the highest debt by that age. Currently that doesn't work, but if I was to implement it the way you said using Power Query or DAX, would that work?