Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |