Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
How can I add "Half Year" to the date hierarchy? I want to enable the trend line so it needs to be continous date type.
Ideally the trend line chart can drill down to Year. Half Year, Quarter 3 different hierarchies
I tried to create a column using below DAX but it is text type and my trend line disapear...
Half Year=YEAR([Date])&" HY "&ROUNDUP(MONTH([Date])/6,0)
Thanks!
Solved! Go to Solution.
Hi @irenelitw629 ,
Here are the steps you can follow:
1. Create calculated column.
Year =
YEAR('Table'[Date])
Half Year =
YEAR([Date])&"HY"&ROUNDUP(MONTH([Date])/6,0)
Quarter =
"Qtr"&" "&QUARTER('Table'[Date])
Month =
FORMAT('Table'[Date],"mmmm")
Day =
DAY('Table'[Date])
2. Check [Date] - click on the three ellipses - Create hierarchy.
3. Add [Year], [Half Year], [Quarter], [Month], [Day] in a customized order - to the created date hierarchy.
4. Result:
Create a slicer with a date hierarchy, and a Visual with the [Date] column as the primary, so that the slicer can hierarchize the Visual
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @irenelitw629 ,
Here are the steps you can follow:
1. Create calculated column.
Year =
YEAR('Table'[Date])
Half Year =
YEAR([Date])&"HY"&ROUNDUP(MONTH([Date])/6,0)
Quarter =
"Qtr"&" "&QUARTER('Table'[Date])
Month =
FORMAT('Table'[Date],"mmmm")
Day =
DAY('Table'[Date])
2. Check [Date] - click on the three ellipses - Create hierarchy.
3. Add [Year], [Half Year], [Quarter], [Month], [Day] in a customized order - to the created date hierarchy.
4. Result:
Create a slicer with a date hierarchy, and a Visual with the [Date] column as the primary, so that the slicer can hierarchize the Visual
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks for your reply. I tried above but still can't enable trend line. Can you send me the file?
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |