Forum Discussion

Sudhavi_84's avatar
Sudhavi_84
Icon for Helper V rankHelper V
5 years ago
Solved

Measures filter

Hi Experts,   I have a visual and filter(list of project's). I can select the projects and visual will update which is perfect.   I have measure which calculates values of each project.    My ...
Need Help
  • edhans's avatar
    edhans
    5 years ago

    yeah, you can create a user-selected parameter via the Modeling tab, New Parameter. Then use SELECTEDVALUE() in a measure to see what the user has selected, and in turn, use that measure as a filter measure. 

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
5 years ago

Hi Sudhavi_84 

 

What I would suggest doing is to use the measure as a filter in your visual and that should allow you to get to what you are looking for?

  • Sudhavi_84's avatar
    Sudhavi_84
    Icon for Helper V rankHelper V
    5 years ago

    Hi GilbertQ ,

     

    Thank you for the response.

    But will it show in filter those projects only with in range specified in visuals?

     

    This didn't worked for me any screenshot please if possible.

     

    Thank you for your help

    • edhans's avatar
      edhans
      Icon for Community Champion rankCommunity Champion
      5 years ago

      See this image. You can put measures in filters for visuals only, not pages, nor entire report. By setting the visual filter for the total measure to just between 3 and 7, only products C, D, E, F, & G show up. A, B, and H are not in the slicer, because their sales are 1, 2, and 9 respectively, outside the 3-7 range.

       

      • Sudhavi_84's avatar
        Sudhavi_84
        Icon for Helper V rankHelper V
        5 years ago

        Thank you very much for your help on this edhans  and GilbertQ .

         

        I have 5 visuals and 4 filters in same page.

        With your step, it is working for one filter, but how can I activate for other 4 filters and 5 visuals? should I apply the same filter in all visuals for this?

        And also visuals are not updating when I apply on filter. But filter is showing range of projects which I need.

         

        Thank you