Forum Discussion
Date Hierarchy doesn't work
Hello Anonymous ,
Try using field parameters to group the year / quarter / Month / Day and then add the value of this parameter to the X-axis and use the slicer to switch between them.
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hello Anonymous ,
you need to have seperate columns for Year, month, Quarter, Day and then you group them as shown in the following link
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parametersIf I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Super UserHello Anonymous ,
you need to have seperate columns for Year, month, Quarter, Day and then you group them as shown in the following link
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Many thanks! I managed to do it. However, last question: how can I set a fixed sorting? i would like to sort the chart by date not by amount. I tried to click on the three dots and then sort axis, but it doenst remain fixed