show visual depending on a value

[sandrasanchez]

Hi everybody!

Im trying to show or not to show a slicer deppending of a selected value of another slicer (with data in differrent tables) is it possible??

I have a table with 2 values 0 and 1 and I have a filter to choose one or another if I select 0 I want muy other filter to be shown other way I want to hide it

thanks so much!!!

[v-haibl-msft]

@sandrasanchez

In this scenario, you need to add one column in the second table and then create relationship between two tables as below.

Turn off Header of the second slicer. Then you should be able to get the expected result.

Best Regards,

Herbert

[sandrasanchez]

It works perfect!!

Now I have another problem, I have three columns, one of them I want to show it depending on the value show and the other column always

Is it any way of doing it?

Thanks so much again!!!

[v-haibl-msft]

@sandrasanchez

Could you please give a sample? Your second problem is not so clear to me. 

Best Regards,

Herbert

[sandrasanchez]

As you see in the image, I have a lot of filters, Canal, BU, Brand... Hospitla & CNH

when I select BusquedaAvanzada = 1, all of them disappears, as you see in the second image, and thats great,  but I want hospital & CNH not to disappear, do you understand me??

thanks so much!!!

[v-haibl-msft]

@sandrasanchez

You can try to change the Show column value to 1 for “Hospitla & CNH”, but do not create relationship between BusquedaAvanzada and this “Hospitla & CNH” table.

Best Regards,

Herbert

[sandrasanchez]

It would be a great idea but all the columns are in the same table....

tanks so much Herbert!!

[v-haibl-msft · Accepted solution]

@sandrasanchez

If so, you can select the BusquedaAvanzada slicer and edit interactions as below.

Best Regards,

Herbert

[sandrasanchez]

Great!!!

It really worked!!!!

Thanks so much!!!

[Habib]

As per my understanding it is not possible.