Forum Discussion
Helper ISmart Narrative date formatting options - no YYYY format
Let me know if I am in the correct location described in your solution.
The column is a true Date field with YYYY formatting. This is how I see the column in Desktop, but it does not carry forward to the Narrative control.
Please clarify "....If your first row date is 15/05/2022 type in the Fomat boc 2022 (yyyy)..."
Not a solution, rather an acknowledgement the desired formatting is not available in Smart Narrative. We are re-factoring the design. We were aggregating at the yearly level as a rapid prototype. However, using Dataflows with Enhanced Compute Engine if very efficient and the added granularity (monthly) improves results in the related Key Influencer viz.
Super UserIf YYYY is missing from your Format drop down list then try this ....
Click on your date field in Fields (far right menu)
then click the Date icon (far left menu)
click on Column tools (top menu) and Format (top menu)
If your first row date is 15/05/2022 type in the Fomat boc 2022 (yyyy).
Congrats, you hace now added YYYY to the format drop down list.
Read this guide
https://www.enjoysharepoint.com/power-bi-date-format/
Please click thumbs up and accept as solution buttons. Thanks 😁
Helper ILet me know if I am in the correct location described in your solution.
The column is a true Date field with YYYY formatting. This is how I see the column in Desktop, but it does not carry forward to the Narrative control.
Please clarify "....If your first row date is 15/05/2022 type in the Fomat boc 2022 (yyyy)..."