Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filtering Slicer with Report values

Hello!

I have a DQ report where I have slicer on Project name (coming from Project dimension) and a graph of project values (coming from fact table). Currently the slicer shows all the values present in project master data table. But I want to show only those project names which are present in the graph coming from fact table. How can I do that?

 

Regards

Priya

Need Help
Show and Tell
Tips and Tricks
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    We can use table visual to work around instead of slicer. Here I created a measure and make the table visual filtered by the measure.

     

    Measure = IF(MAX('dimension'[Project]) in VALUES('fact'[project]),1,0)

     

    Pbix as attached.

     

3 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Anonymous ,

     

    We can use table visual to work around instead of slicer. Here I created a measure and make the table visual filtered by the measure.

     

    Measure = IF(MAX('dimension'[Project]) in VALUES('fact'[project]),1,0)

     

    Pbix as attached.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi v-frfei-msft 

      Thank you for your reply. But I am not able to choose more than one projects when I am using this table as a slicer. How can I achieve that?

       

      Regards

      Priya

      • v-frfei-msft's avatar
        v-frfei-msft
        Community Support
        7 years ago

        Hi Anonymous ,

         

        We can choose more than on projects by CTRL+left click in table visual.