Reply
DougHood
New Member
Partially syndicated - Outbound

Three column Bar Chart

I am currently using a matrix with the values displayed as bars and the visual is exactly what I am looking for. The problem is that when working with the data, I have to hold down the ctrl key and highlight each value to include when I have a long list and want to get rid of the scrol bar. However I have noticed a true bar chart will allow you to use the mouse, hold down the left button and drag accross the selection highlighting it. Then you right click and select include. Much faster. Does anyone know of a three column bar chart like this? Also am curious if anyone knows how to force the numeric value to the outside of the column? (Notice the top bar in the for right column)

DougHood_0-1722689864648.png

 

Thank you,

Doug

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Syndicated - Outbound

Hi @DougHood 
I don't think there is a solution for the first question. Regarding the number next to the bar, you just need to create two measures for each category: one to design as a bar without a number and the other to produce only a number without a bar:


Ritaf1983_0-1722693026341.png

pbix with the example is attached 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

2 REPLIES 2
sroy_16
Resolver II
Resolver II

Syndicated - Outbound

Hello,

 

Please try this and see if it works.

You can customize the position of data labels in bar charts. 

Here’s how to adjust the placement:

Select the Bar Chart you want to customize.

Go to the Format pane (paint roller icon).

Expand the Data labels section.

Set the Position to Outside End to place labels outside the columns. You can adjust this setting to ensure labels are positioned as needed.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Ritaf1983
Super User
Super User

Syndicated - Outbound

Hi @DougHood 
I don't think there is a solution for the first question. Regarding the number next to the bar, you just need to create two measures for each category: one to design as a bar without a number and the other to produce only a number without a bar:


Ritaf1983_0-1722693026341.png

pbix with the example is attached 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)