Forum Discussion
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
Hello! Me again!
Its possible to do this without creating a summarized table?
Hi jhonatas,
Yes, it also support.
Create a calculated column with calculate, then use if state to check the result to return the specify image url.
Regards,
Xiaoxin Sheng
I cant make a COLUMN work with all this variables. The context of column in this mess is getting me crazy.
Hi jhonatas,
Please try to use below formula to create a column on original table:
Image: var temp= calculate(SUM(Table[ValorRealizado])/SUM(Table[ValorRevisado]),Table[Gerencia]=EARLIER(Table[Gerencia]),ALLSELECTED(table)) return if(temp>1, "http://www.clipartbest.com/cliparts/jix/pjG/jixpjGdiE.png","http://www.freeiconspng.com/uploads/checked-correct-right-yes-checkmark-12.png")
Regards,
Xiaoxin Sheng