Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Replace text in IF statement with Image URL in separate table

Hello,

 

Currently using a Multi-row card as a workaround to be able to display both text and a matching KPI image for Red, Amber and Green. The visual combines a two measures named File Size KPI (for text) and File Size KPI IMG (for matching image).

 

My questions are:

 

  1. Rather than a Multicard visual can I compile both Text and Image into a Card visual?
  2. Is there a way that I can just set the IF condition to look for "Red", "Amber" or "Green" in a referencing IconsKPI table and show the corresponding image? I have other report pages in which I want to use the same color coding and want to future proof it in case the naming or the images need to change.
  3. Finally, is there a way to control the size of the image being displayed?

 

Thank you very much in advanced for your help

J

 

 

 

 

Need Help

5 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous 

    1. the default card visual only supports one row, so it is unable to combine both Text and Image into a Card visual.

     

    2.It is possible.

    You could refer to the threads "KPi image inside Matrix table".

    You could find the image you use under the "Miscellaneous Technical (U+2300 to U+23FF)-> 9210" from List of Unicode Symbols.

     

    3.

    If you add a image in a matrix visual, it supports to control the size of the image being displayed.

    See the similar thread.

    Controlling URL Image Size

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thank you v-juanli-msft .

       

      1. Ok. Got it.
      2. I cannot use Unicodes since I want to use colors. AThe links on the threads are currently too complex for me to grasp. And ideally, I would reference the URL on a single table. It looks that even using UNICHAR entails me renaming them in all the different measures in case I want to change it. Am I right?
      3. Thank you again.
      • v-juanli-msft's avatar
        v-juanli-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        Hi Anonymous 

        2. 

        "I cannot use Unicodes since I want to use colors. "

        no, you could change color when you use Unicodes.

        You could apply conditional formatting for that measure or column which uses Unicodes to create symbols.

         

        Here is a simple article about how to use Unicodes in Power BI.

        https://exceleratorbi.com.au/dax-unichar-function-power-bi/

         

        Best Regards

        Maggie

         

        Community Support Team _ Maggie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.