I did some search online and only found ways to achieve this by creating dummy measures( 0 and 1) and using dual axis on measure column to achieve that. However I need the color coded column in the middle of table but since I cant re-order measure column that column is coming at the end.
a) Is there another way of creating Conditional formatting on Dimensions without using measures to achieve that
b) Is there a way to move the measure field(color coded column) into the middle of table?
Thanks and appreciate you for reading my question.
Ramesh- A packaged workbook with what you have would help.