topic Re: How to show a moving Train Image which is crosses a station based on a condition in Developer

How to show a moving Train Image which is crosses a station based on a condition

KR300 — Thu, 06 Mar 2025 06:34:01 GMT

Hi All,

I have 5 stages

Re: How to show a moving Train Image which is crosses a station based on a condition

Anonymous — Fri, 07 Mar 2025 03:00:01 GMT

Hi @KR300 ,

You can try using the following custom visual:

This is the related document, you can view this content:

Slicing and dicing dates: A practical guide to the... - Microsoft Fabric Community

Part 1 – Learn How To HIGHLIGHT Events On Power BI... - Microsoft Fabric Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Re: How to show a moving Train Image which is crosses a station based on a condition

KR300 — Wed, 19 Mar 2025 05:18:42 GMT

@Anonymous , my scenario is different from this i think.

I have 11 Statins 1, 2, 3, 4, ..... 11

I have a simple table

Train Train Station

Train1 Station4

Train2 Station3

Train3 Station8

there is a slicer based on Train Column

when i select any Train, it wll fill up all the columns before the station like Tracking an Order in Amazon app

Re: How to show a moving Train Image which is crosses a station based on a condition

v-venuppu — Thu, 24 Apr 2025 12:18:16 GMT

Hi @KR300 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Anonymous for the prompt response.

yes, it does differ from standard slicer/date visuals.

You're aiming to highlight progress visually across predefined stations for each selected train, like a tracking bar.

Here's how you can implement this in Power BI:

1. Prepare Your Data

Your dataset should look something like:

Train CurrentStation
Train1 Station4
Train2 Station3
Train3 Station8
And a separate table with all station numbers or names:

StationNumber StationName
1 Station1
2 Station2
... ...
11 Station11

2. Create Relationships

No direct relationship between Trains and Stations.
Use a disconnected table approach to control filtering logic manually in a measure.

3. Create a Measure to Mark Progress

StationReached =
VAR SelectedTrain = SELECTEDVALUE(Train[Train])
VAR SelectedStation =
LOOKUPVALUE(
TrainStatus[CurrentStation],
TrainStatus[Train],
SelectedTrain
)
VAR CurrentStationNumber =
LOOKUPVALUE(
StationList[StationNumber],
StationList[StationName],
SelectedStation
)
RETURN
IF(
MAX(StationList[StationNumber]) <= CurrentStationNumber,
"✔️",
"⏳"
)

This will mark all stations before or equal to the selected train's current station with a check (✔️) and others with a pending icon (⏳).

4. Create a Table or Bar Visual

Add StationName to rows.
Add StationReached to values.
Conditionally format with colors or icons using this logic to visually track train progress.

5. Add a Slicer for Train Selection

This way, when a user selects a train, the visual dynamically updates to show the progress across stations.

For more advanced visuals, you can use Custom Visuals:

KPI Indicator or Linear Gauge
Infographic Designer
Or custom visuals like Deneb (for full control using Vega-Lite)

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Thank you.

Re: How to show a moving Train Image which is crosses a station based on a condition

v-venuppu — Mon, 28 Apr 2025 10:31:12 GMT

Hi @KR300 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Re: How to show a moving Train Image which is crosses a station based on a condition

v-venuppu — Fri, 02 May 2025 06:59:33 GMT

Hi @KR300 ,

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 it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

Re: How to show a moving Train Image which is crosses a station based on a condition

v-venuppu — Mon, 05 May 2025 06:34:36 GMT

Hi @KR300 ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.

Thank you.