Slicer to slice another slicer that starts with

[kmansweden]

Hi, I am brand new to PB and need some help to figure this out.

I have a Table with General Ledger accounts, I also created a AccountSeries table to use as a slicer.

I want to use the AccountSeries to filter the Account table and see the result in the left Matrix in pic.

So if I select 20000 and 30000 from AccountSeries it will slice Account to only show rows between 020000-029999 and 030000-039999

I tried to find something like: DISTINCT ( Account[Account Number] where starts with something) without luck.

Is this even possible?

Am I looking at this the wrong way?

I need atleast a hint how to proceed.

 

[jdbuchanan71 · Accepted solution]

@kmansweden 

What you need to do is add the series column to your Account table.  Something like this should do the trick.

Account Series = FLOOR ( 'Table'[Account], 10000 )

Then you can add both columns as slicers and the Account Series will filter the Account slicer.

[kmansweden]

Amazing it works 😁

I've learned so much by this solution and will apply this to many other things.

Thank you so much.

/ kmansweden