cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Will90 Frequent Visitor
Frequent Visitor

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 4
Community Support Team
Community Support Team

Re: Measures in donut chart visualisation

Hi Will90,

 

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

 

Regards,

Jimmy Tao

Will90 Frequent Visitor
Frequent Visitor

Re: Measures in donut chart visualisation

Hi,

 

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

 

1.PNG2.PNG3.PNG4.PNG

Will90 Frequent Visitor
Frequent Visitor

Re: Measures in donut chart visualisation

Can anyone help?

Community Support Team
Community Support Team

Re: Measures in donut chart visualisation

Hi Will90,

 

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

 

Regards,

Jimmy Tao

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 151 members 2,010 guests
Please welcome our newest community members: