Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Spacing between columns (different measures)

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,


Community Support
Community Support

Hi  @cowboyracer ,

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


Refer to :


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.


Hi @v-yangliu-msft, Here is the link to the pbix file: 


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? 



Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors