Forum Discussion
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 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.
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
7 Replies
zapppsr If we could only create KPI's inside PBI Desktop (as in PowerPivot)
Please Vote here!
As of right now we have to create in PowerPivot and Import into PBI - we should be able to do this in PBI
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 YuWith the new conditional formatting by another column, this can be achieved by:
- Creating a measure with just a circle in it: Circle = UNICHAR(9899)
- Creating a Colour Scale measure with 1-7 in it depending on whatever criteria you're using
- Conditional Formatting Font colours based on Colour Scale column
Anonymous Yes! That's very nice. That and many other tricks are now possible...
Thanks for replying.
