Forum Discussion
NickProp28
4 years agoPost Partisan
Conditional formatting matrix
Dear Community, I have 2 table, 'Client_table' and 'Allocation_weekly'. Details for client table: 'week' is the new column with DAX week = WEEKNUM(Client_table[Date],2) For Allocati...
- 4 years ago
Hello NickProp28 ,
You need to write a measure for defining the color code. A sample example is below:
You can use hex codes as well.
And use it in the conditional formatting:
Result:
Cheers!
Vivek
Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter
vivran22
4 years agoCommunity Champion
Hello NickProp28 ,
You need to write a measure for defining the color code. A sample example is below:
You can use hex codes as well.
And use it in the conditional formatting:
Result:
Cheers!
Vivek
Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter
NickProp28
4 years agoPost Partisan