The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
but i want booked and partially shipped to be blue as well. So something like this:
A lot of people had the same issue and I could not find a solution anywhere.
These were the measures used:
Any help would be really appreciated!
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:
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:
and this is how my original table looks :
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...