Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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.
Hi @NoMoreOQ99er,
#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.
Conditional formatting in tables
#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.
Using the Analytics pane in Power BI Desktop
Regards,
Xiaoxin Sheng
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |