Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
kaym
Helper I
Helper I

Line chart marker color based on shipment status

Hello,

I tried making line chart to track shipment status using this video https://www.youtube.com/watch?v=nxvapCD2DoU

It almost works, however, my line chart only changes the color for the marker for current status. All status prior to the current one are same as the line.

this is what i have 

kaym_0-1713819838200.png
but i want booked and partially shipped to be blue as well. So something like this:

kaym_1-1713819878567.png


A lot of people had the same issue and I could not find a solution anywhere.

These were the measures used:

Dummy = 1

kaym_2-1713819949101.png



Any help would be really appreciated!

Thank you!

 

5 REPLIES 5
lbendlin
Super User
Super User

Not sure where the issue is?

 

lbendlin_0-1713829842855.png

 

 

Hello,

Thank you for replying. Instead of "parameter' my dataset has shipment number and the line chart has to filter according to that. If a shipment number has 'delivered' in the status, the line chart does not show all the any status prior to delivered and hence i get a chart looking like this:

kaym_0-1713883635626.png

 



 

 Instead of "parameter' my dataset has shipment number 

 

Not sure how that can work. you need some sort of a progress indicator column. Like the sort index I used.

I made this table:

kaym_0-1713888212557.png

and this is how my original table looks :

kaym_1-1713888254097.png

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors