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,
Solved! Go to Solution.
Hi @Ahmet_Oz ,
I think creating a Calculated Column will do.
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.
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.
This is a must watch for a message from Power BI!
Click here to read more about the December 2020 Updates!
Click here to read the latest blog and learn more about contributing to the Power BI blog!
Mark your calendars and join us for our next Power BI Dev Camp!.