Date slicer not working for Databricks connected tables

[Gokulg]

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

[Anonymous · Accepted solution]

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:

Before You Post, Read This 

Regards,

Xiaoxin Sheng