Forum Discussion

sandrasanchez's avatar
sandrasanchez
Icon for Advocate I rankAdvocate I
10 years ago
Solved

show visual depending on a value

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...
  • v-haibl-msft's avatar
    v-haibl-msft
    10 years ago

    sandrasanchez

     

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

     

    Best Regards,

    Herbert

sandrasanchez's avatar
sandrasanchez
Icon for Advocate I rankAdvocate I
10 years ago

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's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

sandrasanchez

 

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

 

Best Regards,

Herbert

  • sandrasanchez's avatar
    sandrasanchez
    Icon for Advocate I rankAdvocate I
    10 years ago

     

    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's avatar
      v-haibl-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      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's avatar
        sandrasanchez
        Icon for Advocate I rankAdvocate I
        10 years ago

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

        tanks so much Herbert!!