Forum Discussion
Split merged bars in bar chart
Hi, I dont understand what you are trying to do...there must be other better way... you are trying to say that francis has other dimension that is not declare in your table to say that Power bi has to split in 3... the question is why Francis in the same week under the same level (executive) has 3 differents ammounts of days?... if you dont differenciate that you will always have 1 bar....thats the logic.
1st// solution is to use the days column as x axis as well (categorical x axis not lineal)
2nd// solution is to differentiate the level column like Executive 1; executive 2 and so on.
It looks like this graph is automatically summarizing your like data. So all of James' time is executive time, so he gets 1 bar of sum'd executive time. Linda gets 3 different bars because all of her time is different somehow. Francis has 1 bar for all his week 1 executive time because it's all like data.
On some visuals there's an option for how to treat your data called "Do not summarize", which would stop it from doing this. However, it doesn't seem to be available on this graph.
The explanation I found for that was, more or less, it did not make sense not to summarize data in this kind of visual, and that in this case your best bet may be to transform your data somehow (and I'm looking into how you might do that).
EDIT: I didn't have much luck transforming it meaningfully, but maybe a more experienced user will have a solution.