Filter same slicer by selected value

[Analitika]

I need slicer to be filtered depending on selected value

Now if i select English, got

But i need to be like that, without any additional slicers help, only same slicer filter it own values

sendspace.com/file/53yd8u

[MFelix]

Hi @Analitika ,

With the hierarchy slicer you cannot do this in a single table.

I would change not include the language on your slicer table and then use the language from the original table as your first value for the hierarchy slicer so things would look like this:

Don't know if this helps on what you need to achieve but in my opinion is not practical to have all this categorization in a single slicer visual, people will loose themselves on the way it works. But is just my opinion I know some times the users want specific functionalities and the person making the report needs to workaround.

[Analitika]

Client want AND statement which is available only with multiple slicers, what is not look perfect and take a lot of place onpage.

Single slicer use OR statment inside it own, and then do not exactly what client want, As client want see result of ENGLISH AND EUROPE, but not ENGLISH OR EUROPE

And this is filter by columns, so your answer is no correct.

[MFelix]

Hi @Analitika ,

Has you may know slicers due to it's nature of being used to filter the information can only be filter by other slicers or the filter pane so the use of them is very specific.

As in any visualization you cannot select a value on it and filter out the information inside itself, looking at other visualizations if you click on a column of a bar chart within the bsar chart what happens is that the information get's highlighted  so the other values are still there.

As I refered in my answer I know that most of the times the final user want some request that are not totally accordingly to the way the tool works, so I understand when you refer that your client wants to have it in a different way.

I have been working with Power BI since the beginning and regarding slicers there are a couple of questions similar to this but the workarounds can be the following:

• Redoing the order of your hierarchy slicer (as I refer in previous post)
• Creating different slicers for each category but using Dropdowns instead of list (this will create less space)
• Using a bookmark to show and hide slicer and using less space on your report.

Please see attach a file with the example of the two latest options, click the button filter on / off to make them appear and dissapear.

Just putting options on the table but I can understand if you say that my answer is not correct.