Forum Discussion

VijayAntonyM's avatar
VijayAntonyM
Helper I
2 years ago

Conditionally adding Custom Icons placed in Share Point into the dashboard

Hi Team,

 

Good day, Hope everyone doing good.

I would lkie to include the custom icons already placed in the share point directory which i need to use in the power bi visuals conditionally.

 

Example:

1. I already placed the Correct and Wrong icons in the share point : https://Sample.sharepoint.com/sites/

2. I need to use this icons in matrix for profit and loss values using conditional formatting Icons option 

 

Please Help me on this.

 

regards

M. Vijay Antony

 

 

Tips and Tricks

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    VijayAntonyM ,create a measure that returns url based on conditions and use that in visual

     

    set the data category as Image URL from Measure Tools

     

     

     

    example measure

     

    IconAzAvg =
    VAR _val =
    CALCULATE ( AVERAGE ( 'Cost'[Cost] ) )
    -
    CALCULATE ( AVERAGE ( 'Cost'[Cost] ),
    PREVIOUSMONTH ( 'DateDimension'[Date] ) )

    RETURN
    SWITCH ( TRUE (),
    _val < 0, "url1",
    _val = 0, "url2",
    _val > 0, "url3" )

    • VijayAntonyM's avatar
      VijayAntonyM
      Helper I
      2 years ago

      HI,

       

      Could you please vde one example for URL1, URL2.. 

      Where we need to use Share point link, 

       

      Kindly clarify

       

      Regards

      M. Vijay Antony