Forum Discussion
Creating Power BI slicer by combining 2 date/time fields from 2 different dataflows
This is my model view as the settings of my relationships.
Date field in table Date has the DAX formule of "Date = CALENDARAUTO()"
If I add field Date as a slicer and select for example Last 1 weeks. I have no input, table is blank. If I remove the filter then I see my values
Super UserLh_8900 ,
so the solution for this is that go to power query and convert the data type of these columns to date instead of data time and it should work.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Idrissshatila I have changed the column 'Date' from Timesheets and 'DateFrom' from Leaves to data type 'Date' but it doesn't work with this solution. My table is still blank if I filter 😕
Are there other things I should watch/check?
- Idrissshatila
Lh_8900 , did you change them from power query (transform data ) or from the data view ?
and also you should change the data type of the date column .
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡Idrissshatila Only through this did I change it
I have now changed this to 'date' in the 'transform data' view as well.
I see that the date filter works but only for timesheets and not for leave days.Example: the person who worked 40 hours last week has 132 hours of leave. So this is not really correct, any idea where it goes wrong?