Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
vacquaah
New Member

Formatting for Animated Bar Chart

Hello, 

I am trying to figure out a couple things for this Animated Bar Race visual.

1) I can't figure out where to navigate to format the text for the bar chart. I'd like for it to be WHITE since all the bars are different colors. I've gone to every menu item in formatting and am not figuring it out. What am I missing?

2) Not as much a big deal, but I'm trying to do a Top N filter for the Top 2 values. What is the appropriate way to filter so that there are 2 bars per year? In this case, there are 2 different leagues within Major League Baseball. I would like to display top performers from both leagues for each year where applicable.

3) Similar to my first question, is there a way to format for just one color on the bars every year?

 

I have attached a screenshot, but appears I can't attach the the underlying data (.xslx or .csv) Screenshot 2023-09-06 164545.png

 

YearLeaguePlayerSO
2023NLSpencer Strider (ATL)245
2022NLCorbin Burnes (MIL)243
2021NLZack Wheeler (PHI)247
2020NLJacob deGrom (NYM)104
2019NLJacob deGrom (NYM)255
2018NLMax Scherzer (WSN)300
2017NLMax Scherzer (WSN)268
2016NLMax Scherzer (WSN)284
2015NLClayton Kershaw* (LAD)301

 

2023ALKevin Gausman (TOR)207
2022ALGerrit Cole (NYY)257
2021ALRobbie Ray* (TOR)248
2020ALShane Bieber (CLE)122
2019ALGerrit Cole (HOU)326
2018ALJustin Verlander (HOU)290
2017ALChris Sale* (BOS)308
2016ALJustin Verlander (DET)254
2015ALChris Sale* (CHW)274
2014ALDavid Price* (2TM)271
2013ALYu Darvish (TEX)277

 

 

1 REPLY 1
freginier
Solution Sage
Solution Sage

Hi there! 

- For your first question, you have to go into data labels (when you are clicking your visual)-> value -> select the color you want, I will add a screeenshot.

- For your second question, I am not sure.

- For your third question, yes! If you go to the top of the data labels section, you will see "Apply settings to", you can choose the series/bars that you to apply colors to. 

 

Hope this helps!

Zoe 😁

freginier_0-1738830769020.pngfreginier_1-1738830789407.png

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Kudoed Authors