Inline KPI behaviour

Hi jhonatas,

Based on the measure, if ValorRealizado/ValorRevisado >1, displays good image otherwise it’s bad image. But from the screenshot you provided, it seems you place images in wrong location. For example:

In addition, if you want to add good or bad images after grouping, you need to create a summarize table, then place all fields in a table visual. You can follow steps below:  

Create the table.

Add measures.

Calculate percent:

Porcentagem =

var ValorRealizado=SUM([ValorRealizado])

var ValorRevisado=SUM([ValorRevisado])

return

CALCULATE(ValorRealizado/ValorRevisado,ALL(Test))

Format the result to url:

Image = if([Porcentagem]>1, "http://www.clipartbest.com/cliparts/jix/pjG/jixpjGdiE.png","http://www.freeiconspng.com/uploads/checked-correct-right-yes-checkmark-12.png")

Add a calculate column to store and display the url string.

Image Result = [Image]

Create visuals.

Table visual:

Matrix visual:

Use table formula to create a summarize table:

Table = SUMMARIZE(Test,Test[gerencia],"ValorRealizado",SUMX(FILTER(Test,Test[gerencia]=EARLIER(Test[gerencia])), Test[ValorRealizado]),"ValorRevisado",SUMX(FILTER(Test,Test[gerencia]=EARLIER(Test[gerencia])),Test[ValorRevisado]))

Measure and calculate column to display image:

Measure = var ValorRealizado=SUM([ValorRealizado])

var ValorRevisado=SUM([ValorRevisado])

return

CALCULATE(ValorRealizado/ValorRevisado,ALL(Test))

Image = if([Measure]>1,"http://www.clipartbest.com/cliparts/jix/pjG/jixpjGdiE.png","http://www.freeiconspng.com/uploads/checked-correct-right-yes-checkmark-12.png")

Create a table visual:

Regards,

Xiaoxin Sheng