Forum Discussion
Helper IPlease 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.
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?
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
9 Replies
jesengHelper III
Drag the value from Legend to Axis?
- jeseng
Try to drag the value from Legend to Axis?
- themistoklis
Community Champion
Make sure that axis and value section under Visualizations Pane have a field.
Image below
Axis will have the grouping
- BlueTiger
Thanks,
I did try that, but it just goes weird like below.
Those values are Sums and the data I created randomly:
- themistoklis
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
