RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 819
- Office Version
- 365
- Platform
- Windows
Hi guys
I have a stacked bar chart on a Power BI Dashboard which uses a company theme. The theme has like, 10 colours or so which is blues, some green and some pastel purple.
The bar chart is costs per stage of the project, and each project has typically about 10-30 assets. We have about 900 unique assets.
Power BI has attributed a colour to each of these assets and they are every horrible colour you can think of, mustard yellow, puke green, dog**** brown.
As a solution I would like to just have a pool of 20 or so colours it chooses from. Is this possible? I don't mind so much if colours are repeated across the bar chart, I just need there to be a variance in adjacent colours so we can properly spot the variances in cost.
Thanks!
I have a stacked bar chart on a Power BI Dashboard which uses a company theme. The theme has like, 10 colours or so which is blues, some green and some pastel purple.
The bar chart is costs per stage of the project, and each project has typically about 10-30 assets. We have about 900 unique assets.
Power BI has attributed a colour to each of these assets and they are every horrible colour you can think of, mustard yellow, puke green, dog**** brown.
- I can't change the colour for each asset manually because there's hundreds of them and we do add more occasionally.
- Likewise for changing the theme colours
- If I create groups for the asset it does kinda ruin the point of the stacked bar chart - to visually identify variances in asset costs between project stage
As a solution I would like to just have a pool of 20 or so colours it chooses from. Is this possible? I don't mind so much if colours are repeated across the bar chart, I just need there to be a variance in adjacent colours so we can properly spot the variances in cost.
Thanks!
