Abdulazeez Abdullah Profile picture
Jul 23, 2022 27 tweets 7 min read Read on X
Was on a call with @BifolaX yesterday and the issue of colors came up. Felt like I needed to share this. Some of us are bad with colors, that’s who we are. I am one. The best we could do is find a way around this with technology.
For me I believe if there is a problem that technology can’t solve now, it’s just a matter of time before something is created/invented.
So, what do you do if you are bad with colors like me? The answer is simple, deploy technology to solve the problem. You don’t need to have sleepless nights worrying which combination of colors is suitable enough for your dashboard
Two technologies my mentor @MrsLUU1 showed me which you can deploy are.
1. coolors.co
2. imagecolorpicker.com/en
There are some people, you see that color combination, na there talent. If I come across one of their dashboards and I love the color combination, I either save it as an image somewhere or take a screenshot.
Then what next? Take the image to either of those websites and get the color codes from there.
Simple and straight-forward. People post dashboards almost every day, I let them worry about color combinations for me. There is no award for best in color combination.
Let’s take a quick tour on how I go about it. For now, we will be using google search
Step 1 - Search for a nice report online
Step 2 - Upload saved image and extract color codes
You can also create your own color combination
Note that while using coolors.co to create your own matching colors, you don't need to lock in two colors. You can just lock in 1 and it will suggest four other colors that matches the one you locked in
You can also decide to use color picker
Did you the most interesting part, you don't need to go through this step of selecting colors every time, you can just create a reusable theme that you can always import.
This is how.
First export the pallete
Select Code and download
Open the download file and it will look like this
What we need are these set of numbers.
Here is the theme template file you will edit and load into PowerBI.

drive.google.com/file/d/1akdb8n…
You will paste the colors generated into the square bracket
Then put an # sign in front of each colour code to make it look like this
By saving this, you've created a theme template which you can always reuse
All you just need to do is go to view tab in PowerBI
Select the drop down arrow and click on browse for themes
Locate the theme template and select it. if you can't find it, make sure you it is set to All files
On selecting the file, you will get a successful notification
Notice how the colors in my powerbi are exactly the same as those extracted on the websites.
For reuse purpose, you can now always import this theme and use the same set of colors.
Welcome to my tedtalk

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Abdulazeez Abdullah

Abdulazeez Abdullah Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @Itz_Equity

Jun 9, 2022
It’s been a while guys. Hopefully we are back for good. Still on showing you how to do other forms of analysis rather than just telling analysis goes beyond so so and so made the highest sales while so so and so made least etc.
Today we will be focusing on scenario analysis. It’s nothing complicated, trust me.
We’ve all had this had I know moment. If you had known, you would have done something differently. What if I had done this thing this way or that way, maybe the result would have been different.
That is basically you creating scenarios in your head.
A similar thing can be done with data. What if we put some discount on a product and demand increases by a certain percentage, what is going to be the effect on the profit etc. This kind of analysis
Read 29 tweets
May 14, 2022
So, I’ve always said if you call PowerBI just a visualization tool, you don’t fully it’s capabilities. Also, for entry level analyst, analysis goes beyond exploratory analysis. You can take your analysis one level higher with anomaly detection and asking the question of why
it is happening. Good news, you don’t even need to learn any new thing.
So, what is anomaly detection?
Anomaly detection is simply identifying behavior or patterns that is different from the norm. In terms of data, it is simply identifying the datapoints that are different from the normal behavior of all other datapoints.
Read 17 tweets
May 11, 2022
Over the next couple of weeks/months/years😂😂 we would be simplifying DAX to it's most simplistic understandable form
Read 4 tweets
May 11, 2022
Demystifying DAX
Day 2 – Iterative Functions
For this thread we will be looking at Iterative functions and the FILTER functions.
DAX are evaluated by one of the following ways
1.Row context – calculated columns
2.Filter context – measures
What Iterative functions does is allow you to create a measure while employing the row context because by default your DAX measure use the Filter context.

So, what is the row context?
You skipped filter context.

Let’s go into excel to better understand this also
Read 17 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

:(