CODEWITHSUNDEEP
excelpowerbi
sd_dracula
sd_dracula

Reputation: 3896

PowerBI Advenced Date Filtering

In my SQL DB I have a Created Date column which I would like to filter by in my PowerBI Report.

enter image description here

As you can see on the filter in PowerBI it does not filter by year/month/day as you can in Excel.

enter image description here

Can I make the PowerBI date filter show up as in Excel?

Upvotes: 2

Views: 2946

Answers (4)

ibarrau
ibarrau

Reputation: 388

If you want to filter in the page you can add filters by year, month and day with hierarchy or the hierarchy slicer (custom visual).

If you want the filter to be on advanced section (the one in your right) you have to add 3 columns corresponding to year, month and day.

Another approach is to check the preview feature "Show dates as a hierarchy (preview)" https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-january-2018-feature-summary/#dateHierarchy

With that you will be able to get that result.

The best practice in almost all power bi scenarios is to have your own date table

Upvotes: 3

Fabio Akamine
Fabio Akamine

Reputation: 1

You can add columns of Year, Date and Day to the same table or to your calendar table and ADD this coluns at the filter page. This way you can provide the Year, Month and day visualization to users less experienced.

Upvotes: 0

Monika Kastner
Monika Kastner

Reputation: 128

When i deal with date column and for visualization purpose want to filter or add specific on axis or selector I always extract year, month and day from that column

Option 1: Create new calculated table with formula Date= CALENDARAUTO() this would find all date column in your workspace and create date column with gathered dates

Then I create new calculated columns with

    Year= YEAR(Date[Date])
    Month= MONTH(Date[Date]) 
    Day= DAY(Date[Date])

Option 2: You can always make those calculated column in selected table

I truly recommend first option because when then making a chart I just choose 'Date' table as axis (it works like a group, don't know how to name this) and there is no problem with format and for your purpose with filter options

Upvotes: 0

nicolò grando
nicolò grando

Reputation: 407

I think you can't have the same visualization, but, if you want you can use advance filter:

enter image description here

With advance Filtering you can use calendar and hour as filter:

enter image description here

Upvotes: 0

Related Questions