Bryan Kaufman on 29 Dec 2020 00:42:58
When I try to conditionally format in Power BI, it does Lowest/Highest and only lets you custom by Number, not Percentile. A similar table in Excel is robust to outliers since by default it uses a percentile as the middle value for the gradient. For instance, instead of Lowest/Highest value, is there a way to have it automatically be robust to outliers, like it is in Excel. Again, the way it achieves this is by using percentiles, specifically having the midpoint as percentile of 50%.
I understand you can potentially write your measure but is there any obvious option that I am missing? And if you can write a measure is there a trick to make it scalable?
How is something so basic not available in Power BI? Is there a custom table visual I can even buy that can do this? Any help would be much appreciated!