Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi I have a line chart that has been formatted so that the error bars are displaying the results.
I have also useda field parameter in the Y axis
I would like to markers on the visual toshow as green for the lowest point and red for the hihest point. This needs to work if I change the selection in the field parameter filter.
thank you
Richard
Solved! Go to Solution.
Hi, @cottrera, Since no data provided, I have used adventure works data model to replicate the scenario. You can use the given min and max highlight measure according to your data.
Hi, @cottrera, Since no data provided, I have used adventure works data model to replicate the scenario. You can use the given min and max highlight measure according to your data.
Thank you for your quick reponse this solution worked for my error bars
@cottrera , You can create one measure for Max and Min Value
MinValue =
CALCULATE(
MIN(YourTable[YourField]),
ALLSELECTED(YourTable)
)
MaxValue =
CALCULATE(
MAX(YourTable[YourField]),
ALLSELECTED(YourTable)
)
One measure for Marker Color
MarkerColor =
SWITCH(
TRUE(),
SELECTEDVALUE(YourTable[YourField]) = [MinValue], "Green",
SELECTEDVALUE(YourTable[YourField]) = [MaxValue], "Red",
"DefaultColor" // Replace with the default color you want for other points
)
Click on the line chart to select it.
Go to the "Format" pane.
Expand the "Data colors" section.
Click on the "fx" button next to the color option.
In the "Based on field" dropdown, select the MarkerColor measure you created.
Proud to be a Super User! |
|
Hi thank you for responding so quickly unfortunatley as i was using error bards there was no visible format for the marker colours so I could not try you DAX
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
22 | |
17 | |
17 | |
11 | |
7 |
User | Count |
---|---|
27 | |
27 | |
13 | |
12 | |
12 |