Forum Discussion

zapppsr's avatar
zapppsr
Kudo Collector
10 years ago
Solved

Assign a URL image to a Measure

    Hi.   I created a measure, which classifies the % of Goal in a color scale from 1-7. I used the LOOKUP function to create a calculated column to retrieve the URL image, since measures can't ...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    Hi zapppsr,

     

    I agree with Sean that you need to import KPIs from Excel Power Pivot workbook. Please take a look at this article: Import and display KPIs (Preview).

     

    When creating a measure use SUMMARIZE Function, the returned value needs to be aggregated. As you want to create a measure to return a image, in my opinion, it's not supported. In addition to Sean's suggestion, you can also take a look at this article: How to add an Indicator to Power BI Desktop.

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

zapppsr's avatar
zapppsr
Kudo Collector
10 years ago

Thank you for your time and comments. I will lookt into it.

pcraokjr's avatar
pcraokjr
Frequent Visitor
8 years ago

Hi 

 

Did you find any solution for this url issue can you please post here....right now i'm doing some workaround with Unichars but customer would like to load fancy pics from sharepoint site urls.

 

Thanks

  • zapppsr's avatar
    zapppsr
    Kudo Collector
    8 years ago

    Hi pcraokjr

     

    Through measures I don't think it is possible yet.

    But as a column in a table, you can set it to URL Image, and dysplay some icons and pictures.

     

    Here, an example of a Didactic Dashboard using images (Work on Chrome, Firefox. Edge has some issues).

     

    On thing you could do is create Summarized Virtual Tables of the data you want to aggregate, and assign the icons to a columns in this virtual table. Using ADDCOLUMNS and SUMMARIZE. It is not elegant but is a valid workaround.

     

    Hope it helps!