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.
