I want a Line chart where latest build will be displayed black color always

[Lipa]

I want a Line chart where latest build will be displayed black thicker color always and remainig other builds are displayed light pink color ,when new build will be come,it will update automatically and displayed accordingly. I am calculating latest build based on version.

I want this type of line chart .

[v-pbandela-msft]

Hi @Lipa,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Thank you,
Pavan.

[v-pbandela-msft]

Hi @Lipa,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

[v-pbandela-msft]

Hi @Lipa,

Thank you for reaching out in Microsoft Community Forum.

Thank you @GrowthNatives , @ExcelMonke    for the helpful response.

As suggested by GrowthNatives, ExcelMonke.,  I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.

Please continue using Microsoft community forum.

Regards,
Pavan.

[GrowthNatives · Accepted solution]

Hi @Lipa , i understand you are facing an issue with customizing the line color and thickness so that the latest build appears bold and black while all others appear in light pink. 

Assuming you’ve already created these two measures:

AvgValue_Latest = 
VAR LatestBuild = CALCULATE(MAX('Table'[BuildVersion]), ALL('Table'))
RETURN
CALCULATE(SUM('Table'[AverageValue]), 'Table'[BuildVersion] = LatestBuild)

AvgValue_Other = 
VAR LatestBuild = CALCULATE(MAX('Table'[BuildVersion]), ALL('Table'))
RETURN
CALCULATE(SUM('Table'[AverageValue]), 'Table'[BuildVersion] <> LatestBuild)

🖌️ To Format the Line Colors and Thickness:

1. Go to your Line Chart visual in Power BI. (make sure you added both the measures created above to the Values in the chart)

2. In the Visualizations pane, expand the "Lines" section under the Format tab.

3. You will see both lines:

   • AvgValue_Latest

   • AvgValue_Other

4. Set Formatting:

   • For AvgValue_Latest:

     • Color: Black (#000000)

     • Stroke Width: 3 or more for boldness

   • For AvgValue_Other:

     • Color: Light Pink (#f4c2c2 or similar)

     • Stroke Width: 1 (thin)

5. Optionally, rename the legend labels from the Values pane:

   • AvgValue_Latest → "LatestBuild"

   • AvgValue_Other → "OtherBuilds"
     
     

Evern when your data updates with a new build, the measures and formatting will automatically update too. ✅

⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together! 🚀

[Lipa]

here i can see ,its creating only 2 line charts one is black color for latest and other is light pink color. i want all 5 lines should be displayed based on slicer selection. how I can get all 5 lines 

[ExcelMonke]

Hello,

Based on the information you provided, I am assuming you have some sort of "Version" field in your data? i.e. a column that will say "1.01;1.02;1.03", etc?

If so, you can consider using a conditional format formula to highlight your line colours. Maybe something like 

Latest Version = 
VAR _Latest = MAX(Table[Version])

RETURN
CALCULATE(MAX(Table[Build],FILTER(Table,Table[Version]=_Latest))