Measures in donut chart visualisation

[Will90]

Hi,

I have a report that I'm creating to show the current week and then the previous 4 weeks using the measure below but changing -1 to -2 and so on.

Weeks-1 =

var selectedweek =SELECTEDVALUE('Dashboard Data'[Full Date])
var week = LOOKUPVALUE('Dashboard Data'[Week],'Dashboard Data'[Full Date],selectedweek)-1

return

CALCULATE(SUM('Dashboard Data'[Accident Total]),ALL('Dashboard Data'[Full Date]),'Dashboard Data'[Week]=week)

The current week I can put into a donut of Legend and Values, using compliant or not complaint 1 & 0 for red and green. However I cannot do this for the measures week-1, week-2, week-3 and week-4? I can only put the value into Values and not Legend to change the colour of the donut?

[Will90]

Hi,

So i want to present the last 4 weeks in the donuts, but unable to place the measure into Legend - see pictures below.

[Will90]

Can anyone help?

[v-yuta-msft]

Hi Will90,

I'm afraid measures could not be used as legend, please use calculate column instead.

Regards,

Jimmy Tao

[v-yuta-msft]

Hi Will90,

Could you share some sample data and clarify more details about your issue for further test?

Regards,

Jimmy Tao