Forum Discussion
Calendar slicer problem
Hi TaoW ,
The built-in date hierarchy, which is automatically generated by Power BI, breaks down date fields into year, quarter, month, and day hierarchies. This hierarchy may cause filters to behave less than expected in some cases. Specifically, when you use the built-in date hierarchy, Power BI may not correctly apply filters in calculated columns. This is because each level in the built-in hierarchy (e.g., year, quarter, month) is processed independently, rather than applying filters as a whole.
Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
yes, the pic2 is using the field "year" and it can work. But I also need to use other time dimensions, so it'll be convenient to use date hierarchy directly. i just want to know why the "year" in "date hierarchy" hasn't been effected by the calculated column.
ps: my calculated column:
Hi TaoW ,
The built-in date hierarchy, which is automatically generated by Power BI, breaks down date fields into year, quarter, month, and day hierarchies. This hierarchy may cause filters to behave less than expected in some cases. Specifically, when you use the built-in date hierarchy, Power BI may not correctly apply filters in calculated columns. This is because each level in the built-in hierarchy (e.g., year, quarter, month) is processed independently, rather than applying filters as a whole.
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.