No spacing between bars in bar chart - separate bars on x-axis

[Anonymous]

Hello, I have seen that some posts already exist regarding this topic but I could not find a solution that worked out for me.

Currently I'm not able to separate the bars in my bar chart on the x-axis (no inner padding). I think the problem is that they are treated as one category. The variables - which I want to display as separate bars of a bar chart - are columns in one single table (see screenshot). I would therefore need some additional variable which lets me spilt them on the x-axis.

I hope someone has a solution for my problem.

Best regards

[EricHulshof]

If you (un)pivot the data it will do the trick 🙂 if you have sample data i can create a example pbix file for you.

[Anonymous]

I hope the table works for you. I don't know how to add files to this post.

[Anonymous]

Feedback: Feedback Name	PM: Overall satisfaction	PM: Communication	PM: Communication of changes	PM: Quality	PM: Results	PM: Timing	PM end: Continous business	PM end: Fulfilment of needs	PM end: Pricing
Feedback-0000000208	5	5	5	5	5	5	5	5	5
Feedback-0000000209	4	4	4	4	4	4	4	4	4
Feedback-0000000210	3	3	3	3	3	3	3	3	3
Feedback-0000000211	5	5	5	5	5	5	5	5	5
Feedback-0000000212	2	2	2	2	2	2	2	2	2
Feedback-0000000213	4	4	4	4	4	4	4	4	4
Feedback-0000000214	4	4	4	4	4	4	4	4	4
Feedback-0000000215	3	3	3	3	3	3	3	3	3
Feedback-0000000216	1	1	1	1	1	1	1	1	1
Feedback-0000000217	5	5	5	5	5	5	5	5	5
Feedback-0000000218	4	4	4	4	4	4	4	4	4
Feedback-0000000219	2	2	2	2	2	2	2	2	2
Feedback-0000000220	1	1	1	1	1	1	1	1	1

[EricHulshof · Accepted solution]

heya, i can work with that 😉

Before we talk visuals i'd like to show you how to unpivot the data:

i used the following sample data (based on ur screenshot)

Since you are already in the report, press edit queries:

Then go to the transform tab and select all the PM columns. (dont select the feedback number column) and press unpivot columns.

The result looks like this. You can rename attribute and value as you like.

Now press close & Apply to work on your visuals.

Im not entirely sure how you'd like to show it. In the example screenshot i see only one feedback number displayed. Will there allways be 1 displayed? As im unsure i made a couple examples. I will show the visual and the used filters/fields respectively.

i hope this helps. 🙂

[Anonymous]

you're awesome, thank you so much! 🙂