Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

0

#Bug: PBI Time Intelligence Table is Broken

Bug: Time table doesn't filter 

 

Steps to replicate bug: 

1) I created a simple date table which has date hierarchy

2) Added 1 column "_Year" using Dax function Year(xxx)

3) Added date hierarchy to a simple table visual, "_Year" to a simple filter visual

-->> as you can see, when I select year on the filter, it does NOT filter the date hierarchy table below

 

Please fix asap

----------------------

Capture.JPG

Status: Delivered

Hi @QC 

I got a reply from the PG team:

The Core problem is that the hierarchy internally is a different table that has a one way filter relationship with a date table. So the filter on date table can't filter hierarchy.  This is done because the hierarchy might be reused for different dates within model. So they suggested that you could use the year from the hierarchy or change a table to also use calculated columns instead of hierarchy. 

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Investigating

Hi @QC 

Did you test this feature in a previous version? As far as I know, this issue exists in both the April and May versions. The hierarchy can't be filtered by the added time columns unless you add the columns to the corresponding visual.

Also, I don't really understand why you need to create a separate column for filtering, since the time hierarchy itself has the field year. You can just select the field and put it into slicer to do the filtering. Can you provide me with your business scenario and requirements so that I can better handle your problem.

 

vyetao1msft_0-1716444005258.png

Best Regards,
Community Support Team _ Ailsa Tao

QC
Kudo Kingpin
Kudo Kingpin

Hi Tao, please see my comment below:

 

" I don't really understand why you need to create a separate column for filtering, since the time hierarchy itself has the field year."

 

"year" is just an example, it could easily be something else, in complex business analytics a simple time table is not enough, very often we need to create something else, for example, a filter for project milestones, payroll days, leap year, budget period, financial reporting, birthdays, HR days, etc.,.. real business scenarios

 

"The hierarchy can't be filtered by the added time columns unless you add the columns to the corresponding visual."

 

This is exactly the issue, it is a big failure by PBI because time intel table should work generically just like another tables, a data column must be able to filter the table, otherwise entire DAX logic breaks down. The app must follow its own logic. There is no MS document indicating time table work differently than others. Again, this is a major failure that MS needs to correct right away. Please discuss w/ your development team, I think they will agree.

v-yetao1-msft
Community Support
Status changed to: Accepted

Hi @QC 

I have submitted this issue to ICM . I will come back with updates if there is any progress .

 

Best Regards,
Community Support Team _ Ailsa Tao

QC
Kudo Kingpin
Kudo Kingpin

Thank you!

SMfuss
New Member

Second this one , however for me I used an Older PBIX file and saved as new and no longer worked

v-yetao1-msft
Community Support
Status changed to: Delivered

Hi @QC 

I got a reply from the PG team:

The Core problem is that the hierarchy internally is a different table that has a one way filter relationship with a date table. So the filter on date table can't filter hierarchy.  This is done because the hierarchy might be reused for different dates within model. So they suggested that you could use the year from the hierarchy or change a table to also use calculated columns instead of hierarchy. 

 

Best Regards,
Community Support Team _ Ailsa Tao