Change value based on slicer selection

Question

Hi,&nbsp;&nbsp;I have two data sets, that have Date fields, I have created a relationship between "Start of Month" &amp; "Start of Week", as the Start of month is the active relationship the data is not changing in the Visuals of Voice data.&nbsp;&nbsp;Also, I have created measure to convert seconds to HH:MM:SS, which has to be filtered when I select the month slicer.&nbsp;&nbsp;Relationship:&nbsp;&nbsp;Slicers in the report:&nbsp;&nbsp;&nbsp;

djurecic · Answer

Hi&nbsp;Sri_phani&nbsp;,&nbsp;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:&nbsp;https://www.datacamp.com/tutorial/how-to-create-date-tables-in-power-bi-tutorialhttps://www.sqlbi.com/articles/creating-a-simpler-and-chart-friendly-date-table-in-power-bi/&nbsp;&nbsp;

Forum Discussion

Change value based on slicer selection

1 Reply

Related content

Change in category selection changes selected subcategory in slicers

Selected slicer

Single select slicer

Reset Date Slicer (between) when selection in Year Slicer change

Black slicer apper when change Visual