Forum Discussion

Gokulg's avatar
Gokulg
Frequent Visitor
4 years ago
Solved

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 s...
  • Anonymous's avatar
    Anonymous
    4 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:

    Before You Post, Read This 

    Regards,

    Xiaoxin Sheng