Forum Discussion
Dynamic Date
I have a case where I have mulitple dates that define unique variables and I want to be able to customize a date range where people can get totals based on the date range selected. So for instanc...
no you don't need to establish relation, it will work without relation, you just want to get date from the slicer.
https://www.mssqltips.com/sqlservertip/4857/creating-a-date-dimension-table-in-power-bi/
http://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
I don't know what I'm doing wrong then because I can't get the slicer to change anything. Var1 is set to the sum, and clicking on different dates doesn't effect it at all. Do you see something I'm doing wrong?