Forum Discussion

garynorcrossmmc's avatar
garynorcrossmmc
Icon for Advocate IV rankAdvocate IV
5 years ago
Solved

Change Custom Icon Size for Conditional Formatting

Hi all, is there any way to customize the icon size for conditional formatting?  I'm using this measure for to select colored icons for conditional formatting:

 

Icon Conditional Formatting =
SWITCH (
TRUE(),
[vs Last year] <= -0.02, "https://i.imgur.com/x5Q9o12.png",
and([vs Last year]>-0.02,[vs Last year]<0.02), "https://i.imgur.com/9qLo7ww.png",
[vs Last year] >= 0.02, "https://i.imgur.com/6WMjLR8.png"
)
 
However, the icon sizes are huge - I'd like to change this to 8x8 (pixels), the original size of these images.  Is this possible through DAX code or some other way?
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi garynorcrossmmc 

    I have a test by your meausre, your custom icon shows in the size like default icon.

    If the icon in url couldn't meet your requirement, you can try to use the default icon in conditional formatting.

    And you can refer to this video for adding custom icons for conditional formatting.

    Video: Add Custom Icons for Conditional Formatting in Power BI Desktop

    The web you need to get the image url: base64-image

    Your demand is a good idea, while it is not supported to implement in Power BI currently.
    You can vote up this idea for this function：    Let us increase the size of Icons when we conditional format

    Or you can submit a new idea to improve the Power BI.
    It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    Use SVG code if you don't like the icon size. Using external resources like in your example is very wasteful.  Nowhere in the Power BI documentation does it mention URL caching, so you do potentially hit those URLs thousands of times when you interact with your report visual.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi garynorcrossmmc 

    I have a test by your meausre, your custom icon shows in the size like default icon.

    If the icon in url couldn't meet your requirement, you can try to use the default icon in conditional formatting.

    And you can refer to this video for adding custom icons for conditional formatting.

    Video: Add Custom Icons for Conditional Formatting in Power BI Desktop

    The web you need to get the image url: base64-image

    Your demand is a good idea, while it is not supported to implement in Power BI currently.
    You can vote up this idea for this function：    Let us increase the size of Icons when we conditional format

    Or you can submit a new idea to improve the Power BI.
    It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.