Smart Narratives in Power BI Report Server (Sept 2023)
Hi, I'm assuming Smart Narratives are still not available in PBIRS (Sept 2023), correct? There is a Smart Narratives icon now available for visualizations, but it fails to load for any of them in Power BI Desktop for Report Server (Sept 2023). KenSmart Narrative Previous Month pulls 0 and not the value
I have three data points: All Centers which is the total number of cases Status which is one of 6 options but I am working with Open Report Dates (which are all the first of the month. I created a measure to get the date of the previous month which is working fine, but when I try and get the Open cases it is returning 0 and not the value of all centers. My narrative for the most recent month is: Which while throwing an error for multiple columns is in fact giving me the right total. When I try a similar narrative for my PrevMonth measure I get 0. If I replace PrevMonth with 02/01/2023 I get the correct total of 87,193 but need this to be dynamic without having to change that all the time. What am I doing wrong or should (and how would I) create a calculated table or measure first and use that in the narrative. Thanks.
