09-01-2018 09:25 PM
I am searching for a column chart for Power BI for highlighting outliers in the data. I'm needing for it to enable the following:
- Dynamic coloring of the columns, e.g. depending on whether the data point is within specified limits,
- Displaying of upper, lower, or both upper and lower limit lines, and
- Displaying of an average line--or better yet--a trend line.
We found one that allows dynamic coloring of the columns, but it's missing items 2 and 3. Does anyone know if such a component exists? Thank you.
09-03-2018 07:06 PM
#1. Power bi not support change columns color, maybe you can try to create table visual or matrix visual with 'conditional formatting' feature to setting color in visuals.
#2. Please add calculated column or measure to use dax formula with UPPER, LOWER functions to convert characters case.
#3. These analytic lines are in analysis pane, please refer to below document to know how to use them.
09-07-2018 09:14 AM
Thanks. We did try tabular format with conditional coloring, but the manager was hoping for a columnar display with conditional coloring, as it really shows where the bad data is and the limit lines show by how much. Thanks.