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 try calculate table using dax. SUMMARIZE() and UNION() more suitable for you. then use Radar Chart , KPIs as category, Planned and Actual as Y-axis.
If it doesn’t solve your problem, can you share more about your data model or a simple sample .pbix without any sesentive information.
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, v-yalanwu-msft
Thanks. Yes, I can share. This is a training project with no sensitive data.
I don't even know if it's possible, but considering what you said, I would need to achieve this following table, right? However, many measures have different calculations, and some are fixed values. Is it possible to put together theses values in a table?
I inserted the blue columns just to show you the sources quickly.