Creating a template with 25+ colors for report - Is that possible?

Power BI
1

Hey Guys,

Ive been developing reports for some time. but realise thast i dont have a lot of clarity on use of powerbi template for implementing colours in PowerBI.

So, Currently what i do is , i chose a colour and manually assign it to every single Category for all graphs within the erport. This process i know is not efficient.

I also know that I can create a custom theme file in json format and import that as a custom theme, and i have used it a couple of times in past. I want to go this route moving forward, but have some doubts.

In some of my reports i have 25 + categories. - Now, even though i done need to display all categories at same time, but I still have to have a separate color allocation for each one of them.

so i have a few doubts in my mind.

  1. I was reading in one of the forums that we can have a maximum of 8 + 2( black and white) colours in a template file.
  • is that true? how do you implement colours in your reports if you need more than 8 - I am sure i am not alone in this scenario. - do you manually apply colours to all your categories beyond these colours ?

  1. Whats the logic on how powerbi applies these colours to the report ? is there a detailed resource you can point me to ? id like to do some reading on this.

  2. is there a way we can control how these colors from custom theme get assigned in our report ?

1 Like
2

I’d say, having a different colour for every category isn’t best practice when it comes to visualisation.

3

You could create a table that contains the hex code for each category and use DAX to do a lookup for the colour in the conditional formatting.

2 Likes
4

Hello @jsodhi

Did the response from @DavieJoe (Thank you) above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you

5

Hello @jsodhi

We’ve noticed that no response was received from you on the post above.

Just following up if the response above help you solve your inquiry.
If it did, please mark his answer as the SOLUTION.

In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

6

Hi @jsodhi

Due to inactivity, we’d like to conclude that your inquiry was out of the experts’ and users’ bounds.

If you were sure you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, your membership also comes with relevant resources that may help you with your Power BI education, so we advise that you check these resources as well.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!

Thank you for being a part of our community, and we hope you find the help you need.

7

Creating a report template with 25+ colors is possible but may result in a complex and visually overwhelming design. Consider using a more restrained color palette for clarity and readability.