Forum Discussion

jereaallikko's avatar
jereaallikko
Helper III
5 years ago

Help with Filtering & Slicer

Hello all,  I have slight problems with filtering the report in a wanted way. I have created a Power BI table to visualize my problem;     What I am looking for, is to use a slicer based on...
Need Help
jereaallikko's avatar
jereaallikko
Helper III
5 years ago

Hi Greg_Deckler Anonymous & mussaenda 

thanks for the replies.

 

Thanks for the help, that's what I'm looking for. But the real dataset contains more than 200 rows. I could do it like that, but the problem is that there is new data coming in continuously with different numbers and "Level IDs", so each time it happens, I should manually make adjustments to the column code. Is there any other/easier way to do it, so that I wouldn't have to make adjust afterwards?

mussaenda's avatar
mussaenda
Community Champion
5 years ago

Hi jereaallikko,

 

if that's the case,

you can use Text.Contains in power query.

 

Like:

 

if Text.Contains(Text.Upper([Level ID]), "BM")

then "BASEMENT"

else

(your next condition)

 

So everytime you will have new data to come and it detects that there is BM on your Level ID,

it will directly call it as basement. You can also add AND on your condition to get what you rreally wanted.

 

You need to identify their common denominator then you are good to go. insted of using the exact Level ID.

 

Hope this helps!

 

 

by the way, I used Power Query here.