Forum Discussion
Measures in donut chart visualisation
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?
4 Replies
- v-yuta-msft
Community Support
Hi Will90,
Could you share some sample data and clarify more details about your issue for further test?
Regards,
Jimmy Tao
- Will90Frequent Visitor
Hi,
So i want to present the last 4 weeks in the donuts, but unable to place the measure into Legend - see pictures below.
- Will90Frequent Visitor
Can anyone help?
- v-yuta-msft
Community Support
Hi Will90,
I'm afraid measures could not be used as legend, please use calculate column instead.
Regards,
Jimmy Tao