Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe 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.
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)
Year | League | Player | SO |
2023 | NL | Spencer Strider (ATL) | 245 |
2022 | NL | Corbin Burnes (MIL) | 243 |
2021 | NL | Zack Wheeler (PHI) | 247 |
2020 | NL | Jacob deGrom (NYM) | 104 |
2019 | NL | Jacob deGrom (NYM) | 255 |
2018 | NL | Max Scherzer (WSN) | 300 |
2017 | NL | Max Scherzer (WSN) | 268 |
2016 | NL | Max Scherzer (WSN) | 284 |
2015 | NL | Clayton Kershaw* (LAD) | 301 |
2023 | AL | Kevin Gausman (TOR) | 207 |
2022 | AL | Gerrit Cole (NYY) | 257 |
2021 | AL | Robbie Ray* (TOR) | 248 |
2020 | AL | Shane Bieber (CLE) | 122 |
2019 | AL | Gerrit Cole (HOU) | 326 |
2018 | AL | Justin Verlander (HOU) | 290 |
2017 | AL | Chris Sale* (BOS) | 308 |
2016 | AL | Justin Verlander (DET) | 254 |
2015 | AL | Chris Sale* (CHW) | 274 |
2014 | AL | David Price* (2TM) | 271 |
2013 | AL | Yu Darvish (TEX) | 277 |
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 😁
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
86 | |
81 | |
53 | |
37 | |
35 |