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.
I have a requirement for a custom field to be included in a date hierarchy, can anyone advise if this is possible?
Instead of quarters, the client divides a year into 3 so Jan-Apr = T1, May-Aug = T2 & Sept - Dec = T3.
Is it possible to force T1, T2, T3 to be date fields so they can be included in a date hierarchy & slicer?
Hi @keshavagrawal27 , what format is the custom column? I am only able to add date fomat fields to a date hierarchy
Hello @wynhodgkiss ,
You can create a custom conditional column in edit query and map Jan-Apr = T1, May-Aug = T2 & Sept - Dec = T3 in the custom column.
Then drag and drop the newly created custom column in the date heirarchy.
Please mark it as solution if it helps you.
Regards,
Keshav Agrawal.
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 |
---|---|
105 | |
105 | |
88 | |
73 | |
66 |
User | Count |
---|---|
122 | |
112 | |
98 | |
79 | |
72 |