cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

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

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?

 

Image1.JPG

 

Thank you in advance,

 

Regards,

 

Ahmet

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

Best
D

View solution in original post

5 REPLIES 5
Super User III
Super User III

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.
 
123.JPG124.JPG234.JPG
 
Regards,
Harsh Nathani

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
Not applicable

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

Best
D

View solution in original post

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.

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.

 

 

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors