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.
There is a table that keeps track of the progress for each user.
Status is shown in Green for smooth, yellow for no change, and red for delayed.
This is visualized in the matrix visual on the right image.
So far so good, but we would like to furthermore be able to see the phase that has ended as shown in the figure below.
For example, I would like to add color to Steps that have already been finished, but I am having trouble achieving that.
If anyone has any good ideas, or knows of a better way to do this, please let me know.
If you have any questions about my request, please comment and I will respond as soon as possible.
Best regards,
Lopez
@Lopez0090 , For that you need to have some data for previous steps. Create a separate Status and Status Num Table and then create a measure like
Steps= Count(Table[Status])+0
Final =
var _step = maxx(allexcept(Table, Table[User]), Table[Status Num])
return
calculate([Steps] , filter(all(Status), Status[Status Num] <= _step) )
With help of above measure , you can do conditional formatting and icon conditional formatting
You can use another measure if needed
example
Color measure to be used in conditional formatting using filed values
Color Date = if(FIRSTNONBLANK('Date'[Date],TODAY()) <today(),"lightgreen","red")
Color Weekday = if(FIRSTNONBLANK('Date'[Weekday],blank()) in {"Sunday", "Saturday"},"lightgreen","red")
Color Weekday = if(weekday(max('Date'[Date]),2) >=6 ,"lightgreen","red")
If you need custom icon use unichar
example
/////Arrow
Arrow =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, UNICHAR(9650),
_change = 0, UNICHAR(9654),
_change < 0, UNICHAR(9660)
)
/////Arrow Color
Arrow color =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, "green",
_change = 0, "blue",
_change < 0, "red"
)
Thank you for your response!
Two Measure and Status tables were created.
Steps = COUNT('Table'[Status])+0
Final =
var _step = maxx(allexcept('Table', 'Table'[User]), 'Table'[Status Num])
return
calculate([Steps] , filter(all('Status'), 'Status'[Status Num] <= _step) )
However, even using the "Final" measure, I still get this display, what am I doing wrong?
If you don't mind, would it be possible to show us the actual image?
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 |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |