Forum Discussion
MIN MAX
dedelman_clng varshahrame If you really don't want to unpivot your data, you can create a measure to find the the Max Value, which I think you have done, then create a measure per column that will check to see if it's the Max Value and then use that to conditionally format the background or however you want to format it.
I've attached the PBIX as well. Hope this helps.
Community Championvarshahrame - unfortunately, conditional formatting like you are going for operates on a column, not on a row, at least to my knowledge. If you were to "transpose" the table to be a list of attributes and values, then it may be possible, but Pivot/Transpose is not available in DAX (again, to my knowledge).
I'll see if I can bring others into this thread that may have ideas.
David
That is what I was afraid of, everything I had been reading was talking about columns as opposed to rows and then I did come across a few articles that did say to transpose the data in order to do the conditional formatting.
Thank you!