cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tarun16feb Frequent Visitor
Frequent Visitor

Embedding up and down arrow images in visual and changing them based on condition

Hi

 

I need to add an up and down arrow image to my report which displays the arrow based on specific condition.

 

I have created a new measure show_image where

      show_image  = if sum(sales) > 1000 then 'Image url of up arrow' else 'Image url of down arrow'

 

The problem with this approach is that it returns the url of the image but I cannot format a measure to display the image URL. It can only be done with columns. 

and If i use a column then it returns me both the URL. 

 

Now is there a way to display just one result based on the condition.

 

Any help would be appreciated.

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Embedding up and down arrow images in visual and changing them based on condition

Hi @tarun16feb,

 

I'd like to suggest you create a table visual with formatted unichar code as kpi arrow based on conditions, you can take a look at below links to know more about this.

Power BI Desktop/DAX – Using Unicode (Arrows) as Measures in a Table

The DAX Unichar() Function And How To Use It In Measures For Data Visualisation

 

Regards,

Xiaoxin Sheng

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



For learning resources/Release notes, please visit: | |
1 REPLY 1
Community Support Team
Community Support Team

Re: Embedding up and down arrow images in visual and changing them based on condition

Hi @tarun16feb,

 

I'd like to suggest you create a table visual with formatted unichar code as kpi arrow based on conditions, you can take a look at below links to know more about this.

Power BI Desktop/DAX – Using Unicode (Arrows) as Measures in a Table

The DAX Unichar() Function And How To Use It In Measures For Data Visualisation

 

Regards,

Xiaoxin Sheng

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



For learning resources/Release notes, please visit: | |