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
Hi (again) Nolock and everyone else :smileyhappy:
I finally managed to get the Measure working and it looked promising until I used the slicers, as you can see in the two pictures below it doesnt work.
My measure: MyRank = MOD(RANKX(ALL('Efterföljande Kontakt');CALCULATE(MAX('Efterföljande Kontakt'[Ärendenummer]));;ASC;Dense);2)
Feels like everything I try gets hung up on that the measure is not recalculated when I activate a filter, I need the rank to be recalculated with the new slicers sort of. I have also tried to change from DirectQuery to Import and doing some tests on an index column but no luck so far.
// 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?
