Adding a "Start with" to filtering and make it like Buttons.

[Ahmet_Oz]

Hello everyone. 

First of all I hope you all doing well,

Secondly, this is my first post (and question) 🙂 So i hope i will be clear enough so you can give me some tips and help. 

Basically, Here as you can see in the screen shot. I have a filtering option. These are the business areas. For example if it starts with "ES" that means spain. But I want to create something that when my stakeholders "CLICK" on "ES" button, this button will automatically select all the business area that starts with "ES" like below. Because I have other business areas like France, which starts with "FR" so i would like to distinguish like this.  Can we do something like this in Power BI?

Thank you in advance,

Regards,

Ahmet

[harshnathani]

Hi @Ahmet_Oz ,

I think creating a Calculated Column will do.

Abbr = LEFT(Table3[Column1],2)

Pull the Calculated Column in the Filter and it should work.

You can then create a new filter with the actual filter values.

Regards,

Harsh Nathani

[Ahmet_Oz]

Hello @harshnathani  and @TMOCostanzo 

Thank you for your reply. I am using a "Live Cube" which makes me to play only in "Report" level. 

I do not have any tables , I do not import my live cube. Therefore, I cannot create calculated columns. Instead I can only create measures etc.

I can use the bookmark solution as well, however "I need to do it for 13 countries" and every month i need to change the reporting month. Does that mean, i need to open 13 bookmarks each month to change the month? , and still when people see that bookmark are they going to be able to play around like drilling down etc?

Thank you again for your reply. 

[Anonymous · Accepted solution]

IF you can't add columns to tables, bookmarks are your ONLY option.

Best
D

[TMOCostanzo]

I'm at a loss to help at this point. I'm also connected to a live data source.

I was attempting to use the FIND function to get to a hyphen and take the letters behind it. Doing that would allow you to use a slicer with that measure. However, the FIND function does not appear to work to live tables.

The only solution I have is to see if the data owner could put a country code or something into the dataset for you. Perhaps someone else can come up with a solution. Sorry.

[TMOCostanzo]

It depends on the goal. But here is one way.

Create an additional filter on the same field.

Use the Starts With option and enter ES-

Click the Hide Filter option - it looks like a little eye.

Create a bookmark called ES Only

Create a button whose action is to activate that bookmark.

The result will be that they go to that page and they see a single filter that allows additional drill-down. You will need to create another button that shows it with the new filter cleared.

The calculated value would also work, just put that in its own filter.