Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Hi,
So i want to present the last 4 weeks in the donuts, but unable to place the measure into Legend - see pictures below.
Can anyone help?
Hi Will90,
I'm afraid measures could not be used as legend, please use calculate column instead.
Regards,
Jimmy Tao
Hi Will90,
Could you share some sample data and clarify more details about your issue for further test?
Regards,
Jimmy Tao
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |