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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
nicolast29
Helper V
Helper V

filtering table not working

Hi

May be i need holidays, but i don't understand why my slicer didn't filter my table ...

nicolast29_0-1712929773370.png

Here a link toa share file

filter matrix.pbix

 

thanks a lot

 

1 ACCEPTED SOLUTION
Sergii24
Super User
Super User

Hi @nicolast29, this issue seems to be related to the use of "Date Hierarchy":

Sergii24_0-1712930870766.png


If we replace date hierarchy with any other column it works perfectly fine!

Sergii24_1-1712930957751.png

Instead, if you want to use "Auto date/time" hierarchy, you need to add any column of DIM_Calendrier to the visual.

"Auto date/time" creates in a background a hidden date table for you, but it looks like that created relationship is one-to-many from the hidden table to "🗓️ DIM_Calendrier". So you can use the hidden one as a filter, but when adding it to a visual, you need at least one column from "🗓️ DIM_Calendrier", so PowerBI understands that you want to filter "🗓️ DIM_Calendrier" and not the hidden table (which you can't because of single direction of relationship).

As a general reccomendation, I would suggest to turn-off "Auto date/time" for all pbix files and use directly columns of your Calendar table.

Sergii24_2-1712931067707.png

 

 

View solution in original post

2 REPLIES 2
nicolast29
Helper V
Helper V

thanks a lot

Sergii24
Super User
Super User

Hi @nicolast29, this issue seems to be related to the use of "Date Hierarchy":

Sergii24_0-1712930870766.png


If we replace date hierarchy with any other column it works perfectly fine!

Sergii24_1-1712930957751.png

Instead, if you want to use "Auto date/time" hierarchy, you need to add any column of DIM_Calendrier to the visual.

"Auto date/time" creates in a background a hidden date table for you, but it looks like that created relationship is one-to-many from the hidden table to "🗓️ DIM_Calendrier". So you can use the hidden one as a filter, but when adding it to a visual, you need at least one column from "🗓️ DIM_Calendrier", so PowerBI understands that you want to filter "🗓️ DIM_Calendrier" and not the hidden table (which you can't because of single direction of relationship).

As a general reccomendation, I would suggest to turn-off "Auto date/time" for all pbix files and use directly columns of your Calendar table.

Sergii24_2-1712931067707.png

 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.