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,
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?
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 |
---|---|
106 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
84 | |
70 |