Forum Discussion
Anonymous
2 years agoNot applicable
Using the Min Number to do conditional formatting
Hello, I have a table where I'm trying to perform conditional formatting. I have a measure where I'm calculating the MIN of the Reprint Rate Column. However, there's something funky going on wher...
- 2 years ago
Hi Anonymous
You can produce your required output by wrapping the table with 'all' to ignore row filter context in Minx function.
Minx = minx(all('Table'),'Table'[Reprint Rate])Then you can use the conditional formatting on the measure to specify the color as you require.
I attach an example pbix file.
DataNinja777
2 years agoSuper User
Hi Anonymous
You can produce your required output by wrapping the table with 'all' to ignore row filter context in Minx function.
Minx = minx(all('Table'),'Table'[Reprint Rate])
Then you can use the conditional formatting on the measure to specify the color as you require.
I attach an example pbix file.