Forum Discussion

MatthewMcD's avatar
MatthewMcD
Regular Visitor
9 years ago
Solved

Conditional Formatting

Brand new and on the steep learning curve for PowerBI...   I see a lot of people asking for Conditional Formatting. I would like to do something akin to "info graphics" in Excel, where the values "...
Need Help
  • parry2k's avatar
    parry2k
    9 years ago

    Ok so it is possible, here are the steps:

     

    First upload/host these icons (images) somewhere where these can be accessed publically, I'm calling these 3 files as below

     

    warning.png

    failed.png

    passed.png

    unknown.png

     

    You can give your own name to these file and change formula accordingly.

     

    1. Add new column to you dataset, may be call it "ImageURL" add this formula

     

    ImageURL = 
CONCATENATE("http://mywebsite/path/",
if(myTable[Level] = "Warning", "warning.png"
if(myTable[Level] = "Failed", "failed.png"
if(myTable[Level] = "Info", "passed.png", "unknown.png"
))))

    2, On Data modelling tab, set Data Category for ImageURL to Image URL (as shown below)

     

     

    3. Now add table visual on your canvas and add following fields from your table:

     

    Name

    Level

    ImageURL

     

    and you will see icons based on the images.

     

    THanks,

    Parv

parry2k's avatar
parry2k
Super User
9 years ago

Hey MatthewMcD

 

Assuming you have two fields on your table, and make sure you have a column which is numeric and numeric field is not set to "Don't summarize" as shown in the article, once you have aggrgated method (like sum, avg, min or max) applied to you numeric field, you will see "conditional formatting" option. I hope it is helpful. Also assuming you have most updated copy of PowerBI Desktop.

 

Thanks,

P{

MatthewMcD's avatar
MatthewMcD
Regular Visitor
9 years ago

I am running version 2.43.4647.541 64-bit (February 2017)

 

So, conditional formatting only works on numeric fields? Should I convert my text fields to numbers like 1,2,3 and try to format those? This seems so basic, I am struggling to understand why it's so convoluted?

  • parry2k's avatar
    parry2k
    Super User
    9 years ago

    Yes it works only for numeric field, no text. Add ideas if it doesn't exist.