Forum Discussion
Sri_phani
Helper III
Helper IIIChange value based on slicer selection
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 changi...
djurecic
Super User
Super UserHi 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/