Assign a URL image to a Measure

[zapppsr]

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 have this property.

As shown in the image below, the icon works fine in the full granularity of the table.

But when I gruop by "Conta", since the icon information is not in a measure, but in a colum, it groups it in the 3 different colors, blue, red and yellow, as you also can see on the image below.

When not using the icon, the measure that calculate the color number "CM", returns 1, which is the color for the % of the sum of the goal.

I'm struggling on this for days and can't think of a workaround to when I use the icon, it does not split the values, bust keep them grouped as when there is no icon.

I think it can be solved using SUMMARIZE or GROUP but I don't know how to use them properly.

My goal is to assign an icon to a measure, and it must work on filters.

Any other approach or solution also will be appreciated.

Thanks in advance.

[Anonymous]

With the new conditional formatting by another column, this can be achieved by:

1. Creating a measure with just a circle in it: Circle = UNICHAR(9899)
2. Creating a Colour Scale measure with 1-7 in it depending on whatever criteria you're using
3. Conditional Formatting Font colours based on Colour Scale column

[zapppsr]

@Anonymous Yes! That's very nice. That and many other tricks are now possible...

Thanks for replying.

[v-qiuyu-msft · Accepted solution]

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]

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

[pcraokjr]

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]

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!

[Sean]

@zapppsr If we could only create KPI's inside PBI Desktop (as in PowerPivot)

Please Vote here!

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8276622-create-kpi-in-designer-fi...

As of right now we have to create in PowerPivot and Import into PBI - we should be able to do this in PBI