cluster barcolumn visualisation

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Power BI training and help » Cluster bar/column visualisation

Cluster bar/column visualisation

resolvedResolved · Medium Priority · Version 365

Cluster bar/column visualisation

Whenever I create a cluster bar or column visualisation all of the bars as squished into the centre of the axis. Resizing the entire visualisation does not resolve the issue. Nor have I found anything in any of the settings.

When looking at online guides on how to create cluster charts the bars are often spread out to begin with, making it hard to see what setting I might be missing.

RE: Cluster bar/column visualisation

Hi Jasmine,

Thank you for the forum question.

Visuals in Power BI of course show the data you add to the visuals.

I cannot say why your cluster bar or column visualisation do this but the answer must be found in your data model.

Can I ask you to take a screenshot of your visuals and send the screenshot to me, and if you change the visual to a matrix you may find the answer. It may be that you have blanks, but it can be something else.

Please also take a screenshot of your data model. This will help me to better understand the issue.

You can send the screenshots to:
info@stl-training.co.uk

And please write in the subject that the question is for Jens.

Thanks


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Edited on Wed 6 Jul 2022, 11:04

RE: Cluster bar/column visualisation

Hello Jens,

Apologies for the delay in responding, I have discovered the issue was my putting the count in the legend field and not the values field.
Thanks for responding to the request, and best wishes

Jasmine

RE: Cluster bar/column visualisation

Hi Jasmine,

Thank you for the forum question.

Visuals in Power BI of course show the data you add to the visuals.

I cannot say why your cluster bar or column visualisation do this but the answer must be found in your data model.

Can I ask you to take a screenshot of your visuals and send the screenshot to me, and if you change the visual to a matrix you may find the answer. It may be that you have blanks, but it can be something else.

Please also take a screenshot of your data model. This will help me to better understand the issue.

You can send the screenshots to:
info@stl-training.co.uk

And please write in the subject that the question is for Jens.

Thanks


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

 

Training courses

 

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Power BI tip:

Create Interactive Dashboards

Build interactive dashboards by leveraging features like slicers, drill-through, and bookmarks. Slicers allow users to filter data dynamically, while drill-through enables detailed exploration of specific data points. Bookmarks help you save the current view, making it easy to switch between different states of your report.

View all Power BI hints and tips


Server loaded in 0.08 secs.