Route selection - slicer?

Power Query
1

Hi All,

I hope you are well and have had a good week so far.
I would like to request help for my current task.

Route selection.xlsx (14.3 KB)

image
image363×557 6.58 KB

I need to give a user opportunity to choose a route from slicer and then all rows which contains this specific route should appear. I have tried this with text search slicer but there is no success . Would you please help if you have a working idea for my case.

Grateful for help and time as always,

Iwona

2

Hi @Iwona,

Based on your description, see if this works for you, else provide additional details.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    AddKey = Table.AddColumn(Source, "RouteKey", each Text.Split(Text.From([Route]), " ")),
    ExpandRouteKey = Table.ExpandListColumn(AddKey, "RouteKey")
in
    ExpandRouteKey

with this result
image

I hope this is helpful

3

Hi @Melissa ,

Grateful (as always) for your help time and effort.
I wasn’t aware, that my post will have wait for approval and doesn’t let me modify/ delete post whilst is in '‘pending section’.

I have realized , I uploaded incomplete file with one column only.
I have attached PBI file with sample of my proper data .
I need to split all the routes in separate rows and add other information from other rows to each of them. Could you please help.

Road selection dataset.pbix (53.2 KB)
Route selection new.xlsx (16.6 KB)

Many thanks,

Iwona

4

Just a side note…you can delete your post if its pending (waiting for ) approval. I’ve done it many times.

thanks
Keith

5

Hi @Iwona

I’ve incorporated the suggested dim table, see if that works for you.
Road selection dataset.pbix (78.4 KB)

I hope this is helpful

1 Like