Forum Discussion
How to build reusable Stack Column Chart bar auto coloring
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
Anonymous follow this , you can create a measure and use that multiple times in any screen
3 Replies
- gmsamborn
Super User
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
Community Champion
Anonymous follow this , you can create a measure and use that multiple times in any screen
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
