The humble CARD Visual – 5 Tricks to Make it Sexy

Power BI Card Tricks

Card visuals are a great way to show KPIs, important numbers and useful information in Power BI. But most cards look dull and boring. So in this article, let me share 5 ways to spice them up.

Card visuals are a great way to show KPIs, important numbers and useful information in Power BI. But most cards look dull and boring. So in this article, let me share 5 ways to spice them up.

5 ways to spice up the card visuals in Power BI

Trick 1: Show off your colors

Cards with background color

You can apply a strong background color on the card to change the way it looks. Select your card(s) and from the format panel, set background “effect”.

Trick 2: Round those borders

rounded corners on card visual - Power BI

Rounded corners look better than hard edges. Setting them up is so easy too. Go to effects and add borders. Set border radius and match the border color with the background color.

Trick 3: Cast a shadow

If you add a mild-shadow to the cards, they elevate on the report. To set the shadow, go to “effects” and enable the Shadow option. Adjust the default colors if you want.

Trick 4: Subtle Style with Accented Cards

Accent bard on the card visual - Power BI

Ok, now it’s time to really shine. We can creatively mix the shadow effect for a cool accented card style.

To do this:

  1. Set up shadow
  2. Change the shadow offset to Inside and position to “Left”
  3. Now you will get an inside left shadow
  4. Change the position to custom now.
  5. Set blur to 0 and adjust the color & distance.
  6. You get a cool accent bar in the card!

Trick 5: Get a reaction with Emoji 😍

While the first 4 tricks require adjusting the colors or settings, this one requires writing some DAX.

Let’s say you have a [total sales] measure. And you want to indicate how good (or bad) these sales are.

If the sales are above $120M they are good, Anything above $100M is ok and under $100M is bad.

We can create [total sales v2] using below logic:

Total Sales v2 = 
    var ts = [Total Sales]
    var symbol = SWITCH(true(), ts>120000000, "🟢",ts>100000000, "", "")
return
    FORMAT(ts, "$#,##,,M")& symbol

💡 Tip: To get emoji symbols in the DAX, press Windows & DOT (period) keys together.

Demo of the Card Tricks:

Here is a quick demo of how these styling tricks look. Use the slicer to test the emoji card.

Video – 5 Power BI Card Tricks

A while ago, I made a video on this topic (with slightly different tricks). Check it out here if you want more inspiration. (click here to watch the video on YouTube)

How do you style your cards?

Which trick(s) do you use to style your cards and make them pop? Share your thoughts and tips in the comments section below.

Chandoo

Chandoo

Hi there. Welcome to PowerBIProf.com.
My name is Chandoo and I run this site. My mission is to make you AWESOME in Power BI.

Leave a Reply

Your email address will not be published. Required fields are marked *

More From My Blog