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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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