

Turn plain Matrix into brand new visual in Power BI
source link: https://towardsdatascience.com/turn-plain-matrix-into-brand-new-visual-in-power-bi-f87ecd2e7fe4
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.

Turn plain Matrix into brand new visual in Power BI
Use this simple trick to quickly transform traditional Matrix to a more “custom-like” visual


One of the greatest strengths of Power BI is an extremely large collection of visuals, both built-in and custom visuals from AppSource. Honestly said, almost every business scenario can be visually handled in a proper way.
However, there are some really neat and simple tricks where you can transform native Power BI visuals to look like a custom visual. And more than that, you can laud that it was created personally:)
Plain old Matrix
Let’s switch to Power BI and I’ll quickly show you how to transform a plain Matrix visual to something that looks like a custom visual.
As usual, I’ll use the Contoso sample database for demo purposes. Let’s say that we want to show the total sales amount per month for every single brand:


As you can see, nothing special about this matrix. Bunch of numbers, so it’s not so easy to spot highs and lows at first glance and without going deeper into the analysis.
Customizing visual
In order to enable our users to immediately spot what is going on, we will go to the Conditional formatting option under the Format pane and choose Sales Amt as a measure to apply formatting.
The first thing we format is Background color. So, I’m turning this on and go to Advanced controls:

You can see that Power BI automatically applied some gradual coloring, but we want to customize it further. Since my whole report is based on blue colors, I will apply “blueish” tons for this also.

You can notice that the background color of the cells changed to reflect differences in values for the Sales Amt figure, but numbers are still there. Therefore, the next thing we should do is apply the same formatting on the Font color property.
Again, go to Advanced controls and set same color saturation as for Background:

And look what we’ve just got — “Treemap”-like visual, but without limitations related to “Treemap” visual and without need to apply complicated formatting of it:

So, in just a few clicks, we transformed plain old Matrix to a modern-looking custom visual! How cool is that!
This way, we enabled our users to easily spot that, for example, Contoso and Fabrikam sales amount rocks between May and July, and also that the worst month of Contoso is better than any month of any other brand other than Fabrikam!
And the most important thing — we can easily spot these trends in 2 seconds, without getting deeper into numbers. Of course, numbers are still there and if we want to check a specific figure, the tooltip will work like a charm:

Conclusion
Don’t blindly use this trick for every matrix in your report. There will still be many more scenarios where you want to stick with the traditional way of displaying data.
However, you will definitely face some situations when this technique can be beneficial (especially in “wide” matrices with a lot of numbers). And applying this trick would undoubtedly enrich your users’ experience.
Thanks for reading!
Recommend
-
8
7 Proven Ways to Turn Customers Into Brand Advocates In 2021 Getting new customers is always exciting. But real business growth comes from repeat customers. Research shows that return customers spend
-
12
7 Ways to Turn Customers into Brand Evangelists (with Examples)December 15th 2021 new story7Brand eva...
-
9
The Matrix Resurrections: How we made the visual effectsThe Matrix Resurrections: How we made the visual effectsThe film The Matrix Resurrections has been nominated fo...
-
8
Someone modded Sifu into a Matrix game better than any Matrix game Take the Red Pill Sifu! By Cal Jeffrey March 15, 2022, 3:47...
-
6
-
6
Community How NFTs can turn consumers into brand advocates Concept illustration of non fungible token (NFT)Image Credit: VectorStory via Getty
-
4
How community marketin...
-
3
AfleetTurn your users into your brand ambassador armyPayment RequiredAfleet helps you turn your users, employees, and customers into your brand am...
-
7
Turn Wikipedia into a visual masterpiece
-
3
You Will Get Rejected — How You Handle It Will Make You Successful. Here Are 3 Ways to Turn It Into Power To help you navigate moments of rejection and disappointment, here are three powerful ways to fu...
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK