how to build a slicer in power bi based on other two slicers

[ritanoori]

Hello,

for some reasons in my working, I must have two months slicers. as you can see in the picture attached, I have Month and Year Slicers that are from Segmentation table. This table has no relationship with any fact table in my PBI working. In addition, I have Month Year Slicer that is coming from Date table that has an active relationship with fact table.

What I'm trying to do that if a certain month and year selected in Month and Year Slicers, then this combination will be automatically selected in Month Year Slicer.

Thanks =]

[jsh121988]

So I'm not sure this can be done, but I'd like to see if the underlying problem can be fixed.

1. The sort order of [Month Year] is wrong:
   1. Create a CalcColumn called [Month Year Sort] with FORMAT([Date],"yyyymm")
   2. Select [Month Year], in the Modeling tab, select sort by [Month Year Sort]
2. You have multiple relationships to tables that prevent an active relationship from DateTable to SegmentationTable:
   1. Create an inactive relationship
   2. Create measures that use CALCULATE([SomeMeasure], USERRELATIONSHIP(DateDim[Date], Segment[Date]]))