Forum Discussion
Alternating Rows style (in table) based on changes in first field
I have solved it!
I was struggling with getting the measure updated when I applied a value in my slicers but I finally got past that by using ALLSELECTED.
This is my final Measure: MyRank = MOD(RANKX(ALLSELECTED('Efterföljande Kontakt');CALCULATE(MAX('Efterföljande Kontakt'[Ärendenummer]));;ASC;Dense));2)
This Measure gives me 0 and 1 and I can then add conditional formatting on all my fields and set a color for 0 and another for 1.
My only problem now is that the version of Power Bi Desktop on our server doesn't have the Conditional Formatting functionality!! :robotlol:
// Micke
I have solved it!
I was struggling with getting the measure updated when I applied a value in my slicers but I finally got past that by using ALLSELECTED.
This is my final Measure: MyRank = MOD(RANKX(ALLSELECTED('Efterföljande Kontakt');CALCULATE(MAX('Efterföljande Kontakt'[Ärendenummer]));;ASC;Dense));2)
This Measure gives me 0 and 1 and I can then add conditional formatting on all my fields and set a color for 0 and another for 1.
My only problem now is that the version of Power Bi Desktop on our server doesn't have the Conditional Formatting functionality!! :robotlol:
// Micke
Thanks for the solution - this is helpful. I have found though that it only works when the table is sorted by the column that is used to calculate the measure. If I sort the table by any other column then there is a high chance that adjacent rows will end up being the same colour when they should be different colours. Is there any way to make sure that the measure calculates based on whatever sort order is currently being used?