Forum Discussion
NickProp28
Post Partisan
4 years agoConditional 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
Community Champion
4 years agoHello 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
Post Partisan
4 years ago