Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

dynamic slicer based on data in visual

I'm looking for a way to get a dynamic slicer with only value that are available in the visual I want to filter.

I've created a visual 20 suppliers. In the original (not filtered) list of suppliers there are over a 100 suppliers. How can I get only the selected suppliers in the slicer, so that the list is not populated with suppliers that will never be found?

Need Help
  • Baskar's avatar
    Baskar
    7 years ago

    Sorry i misunderstand your reuirement completly Anonymous.

    How you have create column in fact with checking in dim .

     

    Filter = IF(FeitLeveringActueel[rLeveringStatus]=1 && RELATED(DimVoorziening[Wet])="Jeugdwet","Ja","Nee")

     

    Try this. Hope you have relation between two tables.

14 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous

     

    You can do this way.

     

    1, Create a calculated table with the required values.

     

    2. set the relationship for the calclated table and Original Table.

     

    3. Use the suppliers from this table in slicer.

     

    Thanks

    Raj

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Raj,

       

      Thanks for your quick response. I'm a newbie and the 'Calculated table' is new for me. I'v googled it and gonna try to create on and follow your steps.

       

      Thanks,

      Ingrid

  • dobregon's avatar
    dobregon
    Icon for Impactful Individual rankImpactful Individual
    7 years ago

    I'm not sure about that, but you can create a measure like (1 is yes and 0 is no) for the 20suppliers that you want to have in the slicer. 

     

    Then put the slicer with the name of suppliers (100) and then put in the visual filter of the measure and filter by 1 and then in the slicer you should see only the 20 suppliers that you want.

    Other option is to create a simple table (comand creating table o manually) with the list of 20 supllieres. then do a relation ship between both tables and then use the slicer taking into account the column of suppliers from the new table than the "big table"

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      dobregon: that won't work because the '20 supliers' aren't always the same but depending on a day by day situation.
      • dobregon's avatar
        dobregon
        Icon for Impactful Individual rankImpactful Individual
        7 years ago

        ok, the first solution will help you i think (and i think is related to the lastest comment).

         

        Can you create a measure that put yes or not, or 1 o 0 with the conditions to the active the suppliers day by day? with that, you can put this measure in the filter page level or in the filter of the slicer and the you will see only the suplliers that fullfil the condition of the measure