Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
Usually when Title shows current status of values shows Green Color and other previous color shows yellow color( which i added expected result)
I am looking for suggesions( Conditional formatting ) how can we add bar colors present status and prevous status of each title.
Suppose 1st item is Closed (Green color), Previous 3 statuses Active ,Dev Complete and IN Test (Yellow Color).
Solved! Go to Solution.
Hi @Samba777 ,
According to your description, I create a sample:
Here's my solution.
1.Create a table to define the order of Status, the two tables are related with Status column.
2.Create a calculated column in fact table:
Column = RELATED('Status'[Rank])
3.Create a measure.
Color =
IF (
MAX ( 'Table'[Value] ) = 1,
"Green",
IF (
MAX ( 'Table'[Column] )
< MAXX (
FILTER (
ALL ( 'Table' ),
'Table'[Title] = MAX ( 'Table'[Title] )
&& 'Table'[Value] = 1
),
'Table'[Column]
),
"Yellow"
)
)
When apply conditional formating in the matrix visual, you can see the blank values can't show color.
To have the color to show, we should put a value in the current context, so I create a simple blank measure. When put in it, get the correct result:
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This Works Awesome.
Hi @Samba777 ,
According to your description, I create a sample:
Here's my solution.
1.Create a table to define the order of Status, the two tables are related with Status column.
2.Create a calculated column in fact table:
Column = RELATED('Status'[Rank])
3.Create a measure.
Color =
IF (
MAX ( 'Table'[Value] ) = 1,
"Green",
IF (
MAX ( 'Table'[Column] )
< MAXX (
FILTER (
ALL ( 'Table' ),
'Table'[Title] = MAX ( 'Table'[Title] )
&& 'Table'[Value] = 1
),
'Table'[Column]
),
"Yellow"
)
)
When apply conditional formating in the matrix visual, you can see the blank values can't show color.
To have the color to show, we should put a value in the current context, so I create a simple blank measure. When put in it, get the correct result:
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |