Filtering Slicer with Report values

[Anonymous]

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

[v-frfei-msft · Accepted solution]

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]

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]

Hi @Anonymous ,

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