Change value based on slicer selection

[Sri_phani]

Hi, 

I have two data sets, that have Date fields, I have created a relationship between "Start of Month" & "Start of Week", as the Start of month is the active relationship the data is not changing in the Visuals of Voice data. 

Also, I have created measure to convert seconds to HH:MM:SS, which has to be filtered when I select the month slicer. 

Relationship: 

Slicers in the report: 

[djurecicK2]

Hi @Sri_phani ,

 I would recommend using a separate date table and relating it to both of those tables. Use fields from the date table for your slicers. Here is some additional information on date tables:

https://www.datacamp.com/tutorial/how-to-create-date-tables-in-power-bi-tutorial

https://www.sqlbi.com/articles/creating-a-simpler-and-chart-friendly-date-table-in-power-bi/