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've a dataset with Month and some values, I also have the target information and also the average information
I was wondering how do I visualize all of this in the format below
For instance consider the below dataset
value | month |
67.42436398 | November 1, 2020 |
68.32667872 | October 1, 2020 |
68.33531963 | September 1, 2020 |
69.05157567 | August 1, 2020 |
69.99631021 | July 1, 2020 |
70.36755373 | June 1, 2020 |
70.58675967 | May 1, 2020 |
70.34220032 | April 1, 2020 |
70.44322918 | March 1, 2020 |
71.29026149 | February 1, 2020 |
71.16770719 | January 1, 2020 |
70.71456397 | December 1, 2019 |
The target could be 70%, now every values above the target would be green, every value thats on the target would be yeelow and those below would be red and the average line (yellow line) would be constant in my case
I'm having a hard time finding any extenal visuals that can help with this
Thanks
Solved! Go to Solution.
Hi @dollarvora
You can create a measure for dot color like below. Put Month in X axis and Value in Y axis. Format Data colors by Field value based on below measure. Then add a Y-Axis Constant Line with value 70 and an Average Line for Value. You can change their colors and line styles.
Dot Color =
VAR thisValue =
SELECTEDVALUE ( 'Table'[value] )
VAR targetValue = 70
RETURN
SWITCH (
TRUE (),
thisValue > targetValue, "Green",
thisValue = targetValue, "Yellow",
thisValue < targetValue, "Red"
)
Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
Hi @dollarvora
You can create a measure for dot color like below. Put Month in X axis and Value in Y axis. Format Data colors by Field value based on below measure. Then add a Y-Axis Constant Line with value 70 and an Average Line for Value. You can change their colors and line styles.
Dot Color =
VAR thisValue =
SELECTEDVALUE ( 'Table'[value] )
VAR targetValue = 70
RETURN
SWITCH (
TRUE (),
thisValue > targetValue, "Green",
thisValue = targetValue, "Yellow",
thisValue < targetValue, "Red"
)
Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
@dollarvora , You will be able to color, Bu will not able draw excat like. Because power will allow on simple Avg line
I have done 4 color, you can do 2
Line in added in this video
https://youtu.be/Q1vPWmfI25o?t=2847
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |