Forum Discussion
Please help me recreate this bar chart
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
Thanks,
I did try that, but it just goes weird like below.
Those values are Sums and the data I created randomly:
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
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?
Unfortunately this dynamic approach is not supported on PowerBI.
e.g. clicking on the bar and directing you to another object or report.
You can also create an idea on PowerBI
Thanks for your help. It's good to know not to waste my time trying that. Perhaps I will do another item showing the top 10 in a matrix and I can use this bar chart as a filter for it.
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.