Forum Discussion

Will90's avatar
Will90
Frequent Visitor
7 years ago

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's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support

    Hi Will90,

     

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

     

    Regards,

    Jimmy Tao

  • Will90's avatar
    Will90
    Frequent 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.

     

      • v-yuta-msft's avatar
        v-yuta-msft
        Icon for Community Support rankCommunity Support

        Hi Will90,

         

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

         

        Regards,

        Jimmy Tao