Forum Discussion

BlueTiger's avatar
BlueTiger
Helper 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

BlueTiger's avatar
BlueTiger
Helper 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?

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

 

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. 

Why not create a drill through report? Instead of double clicking, you right click and choose the report build to show the detail you need.