Radar Chart - dynamic information

[RS6]

Hey, 

I do hace a big Challenge and i do not know if it is possible. 
I want to create a dynamic radarchart with ten KPIs. The KPIs are from different tables and i used different filters on them. 
i do know that i need one table with to columns. 
one should be the name and the other one should get the needed information from a different table. 

Does someone here in the community know if it is possible and further more know how i can solve it.

let me know pls. 

[Ritaf1983 · Accepted solution]

Hi @RS6 

Yes, it’s possible to build a dynamic radar chart pulling KPIs from different tables using a disconnected KPI table and a SWITCH-based measure. Here's how:

Create a disconnected table with the KPI names:

DAX
Copy
Edit
KPI_Table = DATATABLE(
"KPI_Name", STRING,
{
{"Sales"},
{"Profit"},
{"ConversionRate"},
{"CustomerSatisfaction"},
{"ReturnRate"},
{"NetRevenue"},
{"LeadTime"},
{"EmployeeEfficiency"},
{"CostPerUnit"},
{"SupportTickets"}
}
)
Create a DAX measure that returns the correct value for each KPI:

DAX
Copy
Edit
Selected_KPI_Value =
SWITCH(
SELECTEDVALUE(KPI_Table[KPI_Name]),
"Sales", [TotalSales],
"Profit", [TotalProfit],
"ConversionRate", [ConversionRate],
"CustomerSatisfaction", [CSAT_Score],
"ReturnRate", [ReturnRate],
"NetRevenue", [NetRevenue],
"LeadTime", [AverageLeadTime],
"EmployeeEfficiency", [EmployeeEfficiency],
"CostPerUnit", [CostPerUnit],
"SupportTickets", [OpenTickets]
)
Use a radar chart visual (e.g., from AppSource or a certified visual) with:

Axis = KPI_Table[KPI_Name]

Values = Selected_KPI_Value

However, it's important to point out that radar charts are notoriously hard to interpret and almost always a poor choice from a UX perspective. They don’t support meaningful comparison between KPIs unless values follow the same scale and importance. If your goal is to compare multiple KPIs visually, a combined table + bar chart or a bullet chart layout is a far more effective and readable alternative.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[v-sgandrathi · Accepted solution]

HI @RS6,

Thankyou @Ritaf1983 for your reply on the issue.

I'm glad to hear that your query was resolved! If the response provided by the community member addressed your concern, kindly confirm.

Marking it as Accept Answer and give us Kudos if you found it helpful allows us to ensure that the solutions shared are valuable for the entire community.

If you have any further questions, feel free to reach out!

Thank you for your cooperation!

[Ritaf1983 · Accepted solution]

Hi @RS6 

Yes, it’s possible to build a dynamic radar chart pulling KPIs from different tables using a disconnected KPI table and a SWITCH-based measure. Here's how:

Create a disconnected table with the KPI names:

DAX
Copy
Edit
KPI_Table = DATATABLE(
"KPI_Name", STRING,
{
{"Sales"},
{"Profit"},
{"ConversionRate"},
{"CustomerSatisfaction"},
{"ReturnRate"},
{"NetRevenue"},
{"LeadTime"},
{"EmployeeEfficiency"},
{"CostPerUnit"},
{"SupportTickets"}
}
)
Create a DAX measure that returns the correct value for each KPI:

DAX
Copy
Edit
Selected_KPI_Value =
SWITCH(
SELECTEDVALUE(KPI_Table[KPI_Name]),
"Sales", [TotalSales],
"Profit", [TotalProfit],
"ConversionRate", [ConversionRate],
"CustomerSatisfaction", [CSAT_Score],
"ReturnRate", [ReturnRate],
"NetRevenue", [NetRevenue],
"LeadTime", [AverageLeadTime],
"EmployeeEfficiency", [EmployeeEfficiency],
"CostPerUnit", [CostPerUnit],
"SupportTickets", [OpenTickets]
)
Use a radar chart visual (e.g., from AppSource or a certified visual) with:

Axis = KPI_Table[KPI_Name]

Values = Selected_KPI_Value

However, it's important to point out that radar charts are notoriously hard to interpret and almost always a poor choice from a UX perspective. They don’t support meaningful comparison between KPIs unless values follow the same scale and importance. If your goal is to compare multiple KPIs visually, a combined table + bar chart or a bullet chart layout is a far more effective and readable alternative.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly