Forum Discussion
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,
Simone
2 Replies
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.
Hi Anonymous, 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?
