The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Why is the Clustered Column Chart spacing the data values like this? It appears the chart is keeping a space to match where the previous data values were. For example, the order of colors for the first value is blue, dark blue, orange, purple, pink, ect. For the second value there is a large space between the pink and blue which is where the purple and yellow would go but there are no values. The arrows indicate where I believe there should be no spaces. How do I remove those spaces? It makes the chart hard to understand.
Here is the data I'm working with: ClusteredChartIssue.pbix
Solved! Go to Solution.
Hi @Anonymous ,
the spaces is for the person. 😉
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
Hi @Anonymous ,
the spaces is for the person. 😉
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
Agreed, but the person has no values for the response. So, shouldn't the bars be together rather than spaced?
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
I appreciate the response, but disagree with the functionality. In some cases it makes it too difficultit to discern what value the bar belongs to. For example, does the first red arrow from the left bar belong to Strongly Agree or Agree? Does the second red arrow bar belong to Agree or Neither Agree Nor Disagree. Until I hovered over the bars I wasn't sure from a visual glance and I made the chart. Now multiply that by the hundreds of users I have looking at this and you can guess my inbox will fill up quickly for those who don't know to hover (nor should have to, to discern where a bar value belongs). In the end, I think it's unituitive functionality. The legend denotes what the value belongs to, no need for holding space position, in my opinion.
User | Count |
---|---|
70 | |
67 | |
62 | |
48 | |
28 |
User | Count |
---|---|
113 | |
78 | |
64 | |
55 | |
44 |