Forum Discussion
Date slicer not working for Databricks connected tables
Hi Team,
After connecting to Azure Databricks connector and imported data, the date slicer which shows Start date and End date in single slicer with Between option is not working properly. If i select any date in slicer all the visuals are getting blank even the between date range records are available. The data type is Date/Time and same slicer is working when connected to SQL datasource instaed of Databricks.
Also is there any option to select date in slicer which is out of range dates(ie, dates which are earlier to the dates available in datasource), as of now the dates which are out of model range is grayed out.
or any option to control display date in slicer (ie, model have date from 01-01-2021 to 31-12-2022, i need to display last two months 01-04-2022 to 31-05-2022 and also the other dates available in model should be selectable)
Thanks,
Gokul
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
1 Reply
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