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.
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.
DataZoe Are you able to do a MIN and MAX on the same conditional formatting? I added in my minimum measures and I looked at the conditional formatting and I dont see where you can add the minimum as well as the maximum?
varshahrame Of course, I've attached the PBIX and modified it like so:
Is Max Value Num 1 =VAR thisone =SUM ( 'Table'[Num1] )RETURNIF (thisone = [Max Value],"Red",IF ( thisone = [Min Value], "Green", BLANK () ))