Forum Discussion

gUPTA's avatar
gUPTA
New Member
9 years ago
Solved

Workaround a for Measure to return a URL

I am trying to construct a table in my dashboard with some numerical data for various categories, with an image indicating whether the category is above or below a certain benchmark.  I am using the ...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    gUPTA,

     

    You may use DAX below to add a calculated column.

    Benchmark =
VAR AvgOfDays =
    AVERAGEX (
        FILTER ( Table1, Table1[Category] = EARLIER ( Table1[Category] ) ),
        Table1[Num of Days]
    )
RETURN
    SWITCH (
        TRUE (),
        AvgOfDays <= 90, "https://www.google.com/favicon.ico",
        "https://www.microsoft.com/favicon.ico"
    )
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
9 years ago

gUPTA,

 

You may use DAX below to add a calculated column.

Benchmark =
VAR AvgOfDays =
    AVERAGEX (
        FILTER ( Table1, Table1[Category] = EARLIER ( Table1[Category] ) ),
        Table1[Num of Days]
    )
RETURN
    SWITCH (
        TRUE (),
        AvgOfDays <= 90, "https://www.google.com/favicon.ico",
        "https://www.microsoft.com/favicon.ico"
    )
pcraokjr's avatar
pcraokjr
Frequent Visitor
8 years ago

 

Hi 

but unfortunately calculated column is  not displaying the right KPI Indicators icon, Always its showing me same icon(let’s say Red or Green) irrespective of my return value(Index) in below query.

 

Same query if I created as calculated Measure it works fine but calculate measure not displaying the icon and displaying url as plain text due to limitation on type.

 

Is anyone faced similar issue to display KPI Indicators icons…if so Please provide solution

 

KPI Icon =
VAR Index = IF( [Variance] >0 , 1 ,0)
RETURN
SWITCH (
              TRUE (),
              Index = 0, "https://kjrsw/Red.png",
             "https://kjrsw/Green.png"
)