Forum Discussion
Radar Chart
- 5 years ago
Hi, toyolexparvi ;
You could create a new table as follows:
radarChart1 = var _a=SUMMARIZE('Meta ISC',"kpi","ISC","Planned",SUM('Meta ISC'[meta_isc]),"Actual",AVERAGE('Detalhe de Vendas'[ISC])) var _b=SUMMARIZE('Meta ISC',"kpi","ACESSORIOS","Planned",SUM('Meta AC'[meta_tktac]),"Actual",[tktm ac]) var _c=SUMMARIZE('Meta ISC',"kpi","FIN.EXTERNO","Planned",SUM('Meta Fin Ext'[meta_fext]),"Actual",[fext %]) var _d=SUMMARIZE('Meta ISC',"kpi","EMPLACAMENTO","Planned",SUM('Meta Emplacamento'[meta_emplac]),"Actual",[emplacamento %]) var _e=SUMMARIZE('Meta ISC',"kpi","SEGURO","Planned",SUM('Meta Seguro'[meta_seguro]),"Actual",[seguro %]) var _f=SUMMARIZE('Meta ISC',"kpi","CAPTACAO","Planned",SUM('Meta Captacao'[meta_capt]),"Actual",[captacao %]) var _g=SUMMARIZE('Meta ISC',"kpi","VOLUME","Planned",SUM('Meta Vendedores'[meta]),"Actual",[VENDAS]) var _h=SUMMARIZE('Meta ISC',"kpi","MG MEDIA","Planned",[margem x tkt_medio],"Actual",[MG MÉDIA]) return UNION(_a,_b,_c,_d,_e,_f,_g,_h)The final output is shown below:(and as we can see, I used the formula in your blue box, but the numerical result is different from yours)
Then if we create a radar chart ,Because the difference between these numbers is too large (for example, from 0.085-14378), the display of the radar chart will not be obvious, as follows:
However, if there is no significant difference between our data, the radar chart will be more successful. For example, when we use some of the data, the effect of building a radar chart is as follows:
So, I think you can take my approach and modify the data a little bit to make the radar chart more beautiful.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, toyolexparvi ;
You could create a new table as follows:
radarChart1 = var _a=SUMMARIZE('Meta ISC',"kpi","ISC","Planned",SUM('Meta ISC'[meta_isc]),"Actual",AVERAGE('Detalhe de Vendas'[ISC]))
var _b=SUMMARIZE('Meta ISC',"kpi","ACESSORIOS","Planned",SUM('Meta AC'[meta_tktac]),"Actual",[tktm ac])
var _c=SUMMARIZE('Meta ISC',"kpi","FIN.EXTERNO","Planned",SUM('Meta Fin Ext'[meta_fext]),"Actual",[fext %])
var _d=SUMMARIZE('Meta ISC',"kpi","EMPLACAMENTO","Planned",SUM('Meta Emplacamento'[meta_emplac]),"Actual",[emplacamento %])
var _e=SUMMARIZE('Meta ISC',"kpi","SEGURO","Planned",SUM('Meta Seguro'[meta_seguro]),"Actual",[seguro %])
var _f=SUMMARIZE('Meta ISC',"kpi","CAPTACAO","Planned",SUM('Meta Captacao'[meta_capt]),"Actual",[captacao %])
var _g=SUMMARIZE('Meta ISC',"kpi","VOLUME","Planned",SUM('Meta Vendedores'[meta]),"Actual",[VENDAS])
var _h=SUMMARIZE('Meta ISC',"kpi","MG MEDIA","Planned",[margem x tkt_medio],"Actual",[MG MÉDIA])
return UNION(_a,_b,_c,_d,_e,_f,_g,_h)
The final output is shown below:(and as we can see, I used the formula in your blue box, but the numerical result is different from yours)
Then if we create a radar chart ,Because the difference between these numbers is too large (for example, from 0.085-14378), the display of the radar chart will not be obvious, as follows:
However, if there is no significant difference between our data, the radar chart will be more successful. For example, when we use some of the data, the effect of building a radar chart is as follows:
So, I think you can take my approach and modify the data a little bit to make the radar chart more beautiful.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- toyolexparvi5 years agoFrequent Visitor
Thank you very much. You're my hero. 😁
The difference between our data is that mine was filtered by salesperson and first quarter of 2021.
I'll now try to figure out how to link the radarChart1 to my date table and salespeople IDs.
- Anonymous5 years agoNot applicable
I have a similar requirement to create a Radar (we know it as TADPOLE) but our data is transposed, where we have the Primary field as the project name (200 or so projects) and 7 variables against each project. Data is very simple, but is pulled from a much larger table. Below is a basic extract for 2 projects, we will be using a slicer to select an individual project as part of an overall project review so would end up with 2 different radars, depending upon which project we were reviewing. It's easy in Excel, but I can't get it to show anything but a straight line in Power BI
Project Name Tech Appl Data Process Org Loc'n Env Digital Supplier 2 2 3 3 4 4 1 EUC & Networks 2 3 4 1 2 3 2 Any suggestions gratefully received
Regards
Fred