Forum Discussion

toyolexparvi's avatar
toyolexparvi
Frequent Visitor
5 years ago
Solved

Radar Chart

Hi,   I'm trying to plot a radar chart similar to this one from the native visual documentation. (GitHub - microsoft/PowerBI-visuals-RadarChart: Repo for Power BI Radar Chart custom visual) ...
  • v-yalanwu-msft's avatar
    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.