Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dynamic filter

Hi,

I would like to create 2 dynamic filter that based on data in table.

1. filter of True/False that filter all the lines that reached the 100% in column % Tagged ( measure that based on 2 other mesaures- # Pending/ # Cycles)

2. filter of True/ False for # Cycles> 0 /

Need Help

11 Replies

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    Hi Anonymous 

    Add these two columns to your report and use them in slicer or filter:

    Filter 1 = if([% Tagged]=100%,TRUE(), false())

     

    Filter 2 =if([# Cycles]>0 ,TRUE(), false())

     

    Did I answer your question? Mark my post as a solution!

    Appreciate your Kudos  !!

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      HI,

      i already created a filter like that, but how can i present the filter in the page with Both (false/True) options?

      do i have to add the measure to the table?

      I dont want to present the filter in the table? only in the yellow sign

       

      • Calvin69's avatar
        Calvin69
        Helper III
        4 years ago

        Hi Anonymous ,

        Do you mean something like this:

         

        or:

        Thanks

        H

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    Hi Anonymous 

     

    Use Slicer and add filter column to that. then you can see 2 option to option to select true or false.

     

    Did I answer your question? Mark my post as a solution!

    Appreciate your Kudos  !!

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      i cannot put the filter 1 in th slicer, only in table and then it presents only 1 answer (True/False)

      • VahidDM's avatar
        VahidDM
        Super User
        4 years ago

        Anonymous 

         

        Did you add Filter 1 as a column or measure?

        Please add it as a column and then try it.

         

        Did I answer your question? Mark my post as a solution!

        Appreciate your Kudos  !!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    hi

    the second example is better for me.

    thanks

     

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    4 years ago

    Hi Anonymous ，

    Could you pls share your pbix flie? And remove confidential data.

    You could not create a column ,I think the connect type you ued is live connection.

     

    Best Regards

    Lucien