Forum Discussion
Alternating Rows style (in table) based on changes in first field
Hi,
I am wondering if it is possible to color rows in a table based on changes in one column (A) like below in Picture 1. Sort of the same as Alternating rows (Picture 2) but the color should not change on each row.
Has anyone seen something like that? I tried Matrix mode as well but I was not able to get a satisfying result there either.
With regards
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
4 Replies
Hi Anonymous,
I have a solution for you, but it's a workaround, maybe there is something smarter.
I have created a new computer column MyRank which is a RANK on the column Case. And then computed a modulo by 2 -> it means the values alternate between 0 and 1.
To colors: I only know how to format a column conditionally, so I have to repeat this step for every column in my table - how to format conditionally is described on the screenshort Nr. 2.
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
