cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

 

Balance by Overdue Group

 

I am just using fake data at the moment to create a mockup of what reports we can create.

 

The best I can get from Power BI is the following using a Clustered Bar Chart, I had to create a blank measure = 0 to get a space which I put between each bar, but only appears between the 1st and 2nd for some reason. Plus I can't get the bars to take up the whole vertical space, they just sit in the middle with a massive gap at the top and bottom. Also I can't get the text to display on the left. What am I doing wrong?

 

My attempt

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Memorable Member
Memorable Member

Re: Please help me recreate this bar chart

@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

View solution in original post

9 REPLIES 9
Highlighted
Frequent Visitor

Re: Please help me recreate this bar chart

Drag the value from Legend to Axis?

Highlighted
Frequent Visitor

Re: Please help me recreate this bar chart

Try to drag the value from Legend to Axis?

Highlighted
Memorable Member
Memorable Member

Re: Please help me recreate this bar chart

@BlueTiger

 

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

Image below

 

Axis will have the grouping

 

image.png

Highlighted
Frequent Visitor

Re: Please help me recreate this bar chart

Thanks,

 

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

 

BalanceByOverDueGroup_Attempt2.PNG

 

Those values are Sums and the data I created randomly:

 

BalanceByOverDueGroup_Data.PNG

 

 

Highlighted
Memorable Member
Memorable Member

Re: Please help me recreate this bar chart

@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

View solution in original post

Highlighted
Frequent Visitor

Re: Please help me recreate this bar chart

Thanks for that. I have it working now.

 

BalanceByOverDueGroup_Attempt3.PNG

 

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

 

BalanceByOverDueGroup_Data2.PNG

 

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?

Highlighted
Memorable Member
Memorable Member

Re: Please help me recreate this bar chart

@BlueTiger

 

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

Highlighted
Frequent Visitor

Re: Please help me recreate this bar chart

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.

Highlighted
Anonymous
Not applicable

Re: Please help me recreate this bar chart


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

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors