Use Measure as Legend in Pie Chart or Column in Matrix

[lcs211]

Hi All,

I am working with the below table that contains data from three offices:

I am trying to create a total risk score for each office by adding up all three criteria (Geographic Score, Customer Count, Employee Count), but also apply a parameter weight between 0 and 5 to each to give users the flexibility to adjust the weight of each criteria to dynamically calculate the final risk score

Geographic: 

Customer Count:

Employee Count:

Here's my measure calculation for the Total Score:

I then tried to create a Risk Level (Column) that categorizes the offices based the total risk score into High (> 200), Medium (< 200 and > 150), or Low (< 150) as follows:

However, once I have completed the above steps, I wanted to create a pie chart to show the number of offices in each Risk Level, but I noticed that the risk levels are not dynamic, as the pie chart will not update as I adjusted the weights:

I then tried to replicate the Risk Level but in a measure format as follows:

However, it seems like the Risk Level Measure cannot be added to the Legend field, as it could only be added to the Tooltips:

Is there a way to resolve this issue and add a dynmaic risk level measure to the pie chart as legend?

Thanks in advance

[v-xiandat-msft]

Hi @lcs211 ,

Sorry, add a dynmaic risk level measure to the pie chart as legend doesn't seem to be available on Power BI at the moment.Or you can try to calculate the columns, then change the weights and then refresh all the visuals.

Best Regards,

Xianda Tang

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