Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
May be i need holidays, but i don't understand why my slicer didn't filter my table ...
Here a link toa share file
thanks a lot
Solved! Go to Solution.
Hi @nicolast29, this issue seems to be related to the use of "Date Hierarchy":
If we replace date hierarchy with any other column it works perfectly fine!
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.
thanks a lot
Hi @nicolast29, this issue seems to be related to the use of "Date Hierarchy":
If we replace date hierarchy with any other column it works perfectly fine!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
101 | |
87 | |
73 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |