How to build reusable Stack Column Chart bar auto coloring

[Anonymous]

Hi all,

We have a dashboard containing mulitple pages and each page has several stack column charts. The charts have 'Fiscal Year' for the X-axis and various currencly amounts for the Y-axis. Fiscal year values are in the format of FY2019, FY2020, FY2021, etc. What is the best way to assign color based on the last most digits of the fiscal year and make the method reusable by other graphs in this dashboard and graphs in other reports as well.

For example

FY2019 ------------> 9  -----------> green

FY2020 ------------> 0  -----------> blue

FY2021 ------------> 1  -----------> yellow

FY2022 ------------> 2  -----------> orange  

FY2023 ------------> 3  -----------> maroon

FY2029 ------------> 9  -----------> green

Thank you for your assistance,

Seyed

[gmsamborn]

Hi @Anonymous 

Would something like this help?

https://radacad.com/set-power-bi-data-color-all-visuals-to-follow-same-color-for-the-same-data-point

[VijayP · Accepted solution]

@Anonymous  follow this , you can create a measure and use that  multiple times in any screen

[Anonymous]

Hi VijayP,

Thank you for your assistance. I was able to get it to work. I am going to accespt this as a solution. Just have a follow-up question. I was thinking to connect formatting to an external Excel file and manage color colors externally, that way, any updates to the colors would not require modifying the .pbix file. Any thoughts on how to do that?

Again, thank you for your assistance!

Seyed