Clustered column chart formatting

[eliottbbedard]

Hi everyone,

Since Charticulator isn't working anymore and the number of visuals from the AppSource visuals store is very limited by my organisation, I'm looking for your help to format a clustered column chart.

I'm currently using measures to display some informations on my chart but even if the category width is set to the maximum, the bars are not large enough to fill the space on my canva. To be able to split the columns in multiple group (A,B and C) I created some 0 measures to create space between them but it makes the bar even smaller.

I did try to regroup the value I need for my visual into a calculated table and add my grouping in the x-axis field. Bars are now wider but I'm not able to edit specific column color, only the color for the whole group. The color coding is very important for my visual.

That said, does anyone have any ideas on how to make the bars wider on a visual created from measures, or how to change the color of specific bars? I tried out all the layout options in the X-axis section and in the Columns section of the settings and nothing is working.

Thanks a lot for your help!

[Anonymous]

Hi @eliottbbedard,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

[Anonymous]

Hi @eliottbbedard,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept  as  Solution" and give it a 'Kudos' so others can find it easily.

Thank you,
Pavan.

[Anonymous]

Hi @eliottbbedard.

Thank you for reaching out in Microsoft Community Forum.

Thank you @Ritaf1983  for the helpful response.

As suggested by Ritaf1983, Please provide sample data that covers your issue or question completely, in a usable format

Please continue using Microsoft community forum.

Regards,
Pavan.

[Ritaf1983]

Hi @eliottbbedard 
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523