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 UserHi again Tomcat3
That looks great. Well done !
You have defined Model Year Date with Date Type = Date (eg the source data = 15/05/2022)
But you have specfield the display format as yyyy.
So 15/05/2022 will still be stored as 15/05/2022 in your dataset,
but it will display as 2022 in visuals.
You are only showing partial screen shots so it is diffcult for me to see or understand you problem.
Please try provide as much info as possible.
The best method is to use Enter Data to copy and paste some demo data, save a PBIX on OneDrive, set share view access and post the the hotlink. Click here for an example
If you can create and share an example PBIX with the problem then it will help with a speedy resolution. 😁
Helper II am posting a more inclusive screenshot. I am well aware of internal date storage and display formatting options. My question pertains specifically to formatting options for Smart Narrative (see original post).
The dropdown formatting control linked to the narrative does no have a "YYYY" option, the shortest available is "YYYY-MM" as shown. See lower-left corner where "2000-01" is displayed rather than the preferred "2000"