Need help in Handling dynamic values into Slicers from different tables

[ramshoney1225]

I have below Tables which i need to use for reporting.

Month table (Confirmed Dimension) joined to between TableA and TableB
Year Table (Confirmed Dimension) joined to between TableA and TableB
Country Table (Confirmed Dimension) joined to between TableA and TableB

I have two pages PageA and PageB

Now I need to use Slicers from confirmed dimension Month Slicer, Year Slicer, Contry Slicer

Now the problem,

when i use (Month Slicer) from "Month Table" it is showing all the 12 months where i need to show (January, ebruary, March, April) for Page A. Now i manually added the months that are associated to Page A

when i use (Year Slicer) from "YearTable" it is showing all the 4 years where i need to show (2019,2020) for Page A. Now i manually added the years that are associated to Page A

when i use (Country Slicer) from "Country Table" it is showing all the 21 countrys where i need to show (Albania, Belarus, Cameroon, United States) for Page A.

Simillary I'm doing the same for TableB report which is of manually process.

My requirement is even tho i use the Month,Year,Country from (Month table, Year table, Country table ) to PAGEA , i need to see the assoicate years need to come, assoicate month need to come, associate country need to come ) for PageA.

how to do that dynamically simillary to PageB report.

[ramshoney1225]

Hi @amitchandak 

Thanks for the quick response, but my is like all confirmed dimension values using in Slicer

as below with short descritipon.

Month table has 12 months of Data 

TableA has 4 months of data

we created a relationship Monthtable joined with TableA.

My requriment is to use Month slicer from Month table in PageA dashboard which i'm using TableA data. Whenever i use month then it is showing 12 months, but for TableA im getting 4 months.

Now, in Month slicer (Filter section) i'm adding the 4 months that are coming froM TableA. which is a manual process. I need to handel in such a way if i use Month Slicer from MOnth table it should show the months that are coming from tableA.

Simillary when i create a new dashboard PageB with TableB there for monthslicer from Monthtable should show the months that are associted to TableB.

[v-easonf-msft]

Hi, @ramshoney1225 

In addition to manually filtering the data, you can also apply a measure to the visual filter pane to filter slicer value.

You can try code similar to the following：

Measure = IF(MAX('Month Table'[Month])IN VALUES(Table1[Month]),1,0)

Best Regards,
Community Support Team _ Eason

[amitchandak]

@ramshoney1225 , Based on what I got

if you want to restrict a slicer based on fact values then you can create a measure countrows(Fact) and then use that visual level filter and check for not blank