Forum Discussion
Inline KPI behaviour
Hello friends!
This is my first post here if something is not on the correct form please let me know.
Fist, this is my data
id gerencia cr ValorRevisado ValorRealizado
| 1 | Gerencia A | CR1 | 15000 | 12578 |
| 2 | Gerencia B | CR2 | 20000 | 10000 |
| 3 | Gerencia A | CR2 | 1300 | 1700 |
| 4 | Gerencia A | CR3 | 500 | 350 |
| 5 | Gerencia B | CR4 | 900 | 910 |
| 6 | Gerencia C | CR1 | 800 | 750 |
| 7 | Gerencia C | CR2 | 50000 | 50000 |
| 8 | Gerencia C | CR3 | 500 | 1500 |
And this is what im trying to do:
- My rule is :
Measure: Porcentagem = (ValorRealizado / ValorRevisado)
Column (Image URL) = IF Porcentagem > 1: good image else bad image;
I can figure what is happening on table A.
I know what is happening on table B too but my doubt is, is this correct?
I expected somethind like table C, where the rule is applyed after the grouping..
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
9 Replies
maybe i need to write some more details?
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
Hi guys,
When you move the cursor over the icons, the url pops up. Is it possible to no longer occur?
Thank you,
Simona
Hello! Me again!
Its possible to do this without creating a summarized table?
