Forum Discussion
Using the dates from date slicer in queries to filter data for visualization
Post PatronWere you able to solve this? I am having same issue.
I need to know based on the date selected by the user the active stores. They have termination dates and anticipated active dates so being able to see how many are active as of a date is important.
Hi,
I can tell you what my findings were, I had a hard time figuring this out as Power BI apparently doesnt work like SSRS or most other reporting tools. the only way I could work around this was by flattening my dataset. I joined my dataset with a calendar dimension and generated one row of an entity for each monthyear that entity was to be filtered for and a column with monthyear. Then I set the dateslicer in Power BI with that monthyear column which allowed slicer to filter records for each monthyear.
If the relationships are set right with all other datasets, then the slicer will filter data for everything. Mostly I found it was the relationships not set correctly which caused data to not filter correctly once the base data was all set correctly.
Hope this helps.