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.
Hey everybody,
Can the funnel visual show both the positive and negative values? I would like to show positive values in blue and negative values in red color.
- here the negative values should be shown with a red bar.
Thank you for any suggestions.
Cheers,
Solved! Go to Solution.
File attached here
Yes you can do it using Color Saturation Property of the Charta and a MEASURE.
Please see the attached file.
STEPS:
1)First create a MEASURE to assign a 0 value to negative values and 1 to positive values.
This will be used in Color Saturation Property
2)Next add a MEASURE or a COLUMN to convert negative values to positive using ABS function
3) Select Colors from DataColors
File attached here
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 |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |