Forum Discussion
Date slicer not working for Databricks connected tables
- Anonymous4 years ago
Hi Gokulg,
When you use the date field as the source of the slicer, the filter effect only checks the corresponding date field values. For the scenario, your visual shows the blank because the table may not have matched records on the selected date ranges.
If you want to filter on the date ranges that are defined by multiple date fields, you can try to create a new table that expand row records. Then you can link to the raw table and use the new table date field as slicer to show correspond records.
Solved: Spread revenue across period based on start and en... - Microsoft Power BI Community
In addition, you can also take a look at the following link 'start date', 'end date' part if helps:
Regards,
Xiaoxin Sheng
Hi Gokulg,
When you use the date field as the source of the slicer, the filter effect only checks the corresponding date field values. For the scenario, your visual shows the blank because the table may not have matched records on the selected date ranges.
If you want to filter on the date ranges that are defined by multiple date fields, you can try to create a new table that expand row records. Then you can link to the raw table and use the new table date field as slicer to show correspond records.
Solved: Spread revenue across period based on start and en... - Microsoft Power BI Community
In addition, you can also take a look at the following link 'start date', 'end date' part if helps:
Regards,
Xiaoxin Sheng