Enhance the Card Visual in Power BI with Conditional Formatting

The conditional formatting can be used in many visuals in Power BI, and I have explained an example of doing it in table visual. This feature is also available in the Card Visual in Power BI, However, I have seen a very few people using it. In this short blog article, I’ll explain how this feature works. If you want to learn about Power BI, read Power BI book from Rookie to Rock Star.

Card Visual

The default Card visual in Power BI is a great visual to show you one single value; text, date, or number. Below is an example of a Sales Amount value visualized in a Card Visual:

The visual above shows the Sales Amount for every English Education category. However, the value is always the same colour. Let’s say you want to do conditional formatting in the visual and say if the value is less than $5M, between $5M and $8M, and more than $8M. Let’s see how you can do that with conditional formatting.

Conditional Formatting in the Card Visual

Finding the conditional formatting in the card visual is a bit tricky. there is no separate option for that. You need to go to the Format tab of the visual, and then expand the Data Label. the right beside the Data Label’s colour you need to hover your mouse, and you will find a three dots icon appearing, which if you click on it, you will see Conditional Formatting.

Now in the Conditional Formatting tab, you can apply it in different methods. for example, you can choose Rules, and then

The Rules mode will give you the ability to put custom roles as below;

You might ask; what if I want to define rules dynamically and compare it with other values. In those cases, I suggest using the Format by “Fixed Value” which you can select a Measure. I have explained in this article in details how you can do custom dynamic formatting using Fixed Value and Measures.

Result

Here is the result now

Conditional Formatting everywhere

Conditional formatting is not just for colours. You can even use it for the title of card visual too. You can build titles such as Sales Amount of the High School category etc. For that, I created a measure to create a concatenated label:

Title for Card Visual = 
"Sales Amount for "
&FIRSTNONBLANK(DimCustomer[EnglishEducation],0)

And then this can be used as Format by Fixed Value, and set the format by this measure above.

And now in addition to the colour changes, we also have the title change:

Summary

Conditional Formatting is your superpower in the visualization. Always consider doing that. In this short article, you learned how easy and quick is to create a card visual with conditional formatting. If you are interested to learn more about conditional formatting check the below articles:

Reza Rad on FacebookReza Rad on LinkedinReza Rad on TwitterReza Rad on Youtube
Reza Rad
Trainer, Consultant, Mentor
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for 12 continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand, Power BI Summit, and Data Insight Summit.
Reza is author of more than 14 books on Microsoft Business Intelligence, most of these books are published under Power BI category. Among these are books such as Power BI DAX Simplified, Pro Power BI Architecture, Power BI from Rookie to Rock Star, Power Query books series, Row-Level Security in Power BI and etc.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.

3 thoughts on “Enhance the Card Visual in Power BI with Conditional Formatting

Leave a Reply