Spacing between columns (different measures)

[cowboyracer]

Hi there 😊

I'm a beginner and need some help 🙂 

Hopefully the chart below shows the score of department WKZ (WEL Wijk) compared to the scores of the other departments (NIET Wijk).                                                                                                 
(Afdeling = Department)

It’s about phonecalls answered (WEL opgenomen) or Missed (NIET opgenomen).

Therefore I made (quick?) measures.
For department WKZ I use (quick?) measures “WEL Wijk NIET opgenomen”, “WEL Wijk WEL opgenomen” and I use “Count of opgenomen ja/nee” (for all the calls).
For other departments I use (quick?) measures “NIET Wijk NIET opgenomen”, “NIET Wijk WEL opgenomen” and I use “Count of opgenomen ja/nee” (for all the calls).

Because I don’t use the same measures for all categories (the departments) I get differences in the chart in the visualization of the two different categories (WEL / NIET Wijk).
You can see that the name of the category WKZ is at the right of the 3 columns, the names of the other categories are on the left of the 3 columns.
That’s because in both cases, not all the columns are shown, because not all the columns apply to both categories.
But… Can I change this?
Can I get the spacing between “WKZ” and the next (other) department the same as between the other categories?
And, can I get the labels at the same position in relation to the columns shown?

Hope to hear from you!

Kind regards,

Simone

[v-yangliu-msft]

Hi  @cowboyracer ,

You can consider selecting the relevant columns for Unpivot Columns and comparing them through mesaure.

Refer to ：

https://docs.microsoft.com/en-us/power-query/unpivot-column

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[cowboyracer]

Hi @v-yangliu-msft, Here is the link to the pbix file: https://www.dropbox.com/s/w7kzflrjxw4updc/TelephoneCalls%20Forum.pbix?dl=0 

I also copied an image of my visual As you can see I marked the distance between Dep A and Dep B with a black line, the distance between the other Dep's with a pink line. The pink lines are shorter than the black line --> The space between Dep A and Dep B is bigger than the space between the rest. I want the same space between all the collumns. How to fix this?