Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Issue] Inconsistent date filter behavior in table preview UI #924

Closed
vdvoorder opened this issue Jun 26, 2023 · 2 comments
Closed

[Issue] Inconsistent date filter behavior in table preview UI #924

vdvoorder opened this issue Jun 26, 2023 · 2 comments
Assignees
Labels
issue: bug Confirmed as a bug in TE3
Milestone

Comments

@vdvoorder
Copy link

vdvoorder commented Jun 26, 2023

Describe the issue
In the table preview UI, the filtering behavior on date columns is inconsistent/unexpected in two ways:

  1. The options shown in the Values pane are only a subset of the actual values.
  2. When selecting multiple options only the first selection is applied.

Which version are you currently using?
Tabular Editor 3.8.0 - Consultancy Edition

To Reproduce
Connect to Power BI dataset, remote or local.

Steps to reproduce the behavior:

  1. Right-click a table with a date column
  2. Click on 'Preview data'
  3. Hover the date column and click the filter icon that appears
  4. Select the 'Values' tab
  5. Expand year and month levels, select a first day and then a second day

Expected behavior

  1. I expect all available options to be shown in the 'Values' tab.
  2. I expect multiple selections to be included as OR filters; if I select the 3rd and 4th day of the month, I expect 2017-01-03 OR 2017-01-04 filters to be applied, not just 2017-01-03.

Screenshots

Screenshot 2023-06-26 160215

Screenshot 2023-06-26 160346

Desktop (please complete the following information):
Windows 10

@otykier otykier added the issue: bug Confirmed as a bug in TE3 label Jun 28, 2023
@otykier
Copy link
Collaborator

otykier commented Jun 28, 2023

Thanks for reporting - this is definitely a bug. As a workaround for now, use the Date Filters instead of Values, when filtering a date column - this should work, even if the filtered values do not appear in the Values list.

For example, you can use the "Equals" or "Between" option to filter to a specific date or range of dates:

image

@otykier otykier added this to the 3.9.0 milestone Jul 14, 2023
@DBojsen DBojsen self-assigned this Jul 18, 2023
@DBojsen
Copy link
Collaborator

DBojsen commented Jul 24, 2023

Hi @vdvoorder

This is now fixed in 3.9.0.
Thanks for reporting.

BR David - TE3 Support

@DBojsen DBojsen closed this as completed Jul 24, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
issue: bug Confirmed as a bug in TE3
Development

No branches or pull requests

3 participants