Forum Discussion
Helper IYTD calculations using Month-Year
Hi romilv1 ,
You can click the small arrow next to the date field and select hierarchy. But when you create a relationship (many-to-one or one-to-many) between tables with Date , only the dates on one side show the date hierarchy. For more information, please refer to the link: Solved: Date hierarchy not available - Microsoft Fabric Community.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IThanks Anonymous This is similar to the solution what I was looking for. How can we format the slicer to display dates in Month Year format while retaining "Date" date type?
Hi romilv1 ,
You can click the small arrow next to the date field and select hierarchy. But when you create a relationship (many-to-one or one-to-many) between tables with Date , only the dates on one side show the date hierarchy. For more information, please refer to the link: Solved: Date hierarchy not available - Microsoft Fabric Community.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.