Unable to populate coefficient in Smart Narratives

[raprabhakaran]

Hi All,

I am working with this dataset.

Eurostat - Data Explorer (europa.eu)

I want to create smart narrative to show the trend coefficient.

PBI summarized the solution for me but it doesn't allow me to copy and paste that summarized solution onto another text box.

This is what the summarized text looks like:

Between 2015 & 2020, France had the largest increase in Total Contribution (140.46%) while United Kingdom had the largest decrease (100%).

Both 140.46% & 100% were autogenerated by PBI using the summarize option.

When clicked on the KPI - it shows the below narrative:

• 140.46%: % change between start and end of time series for Country with highest trend coefficient.
• 100%: % change between start and end of time series for country with lowest trend coefficient.

When I try to create the similar narrative I get the below question: 

[v-eqin-msft · Accepted solution]

Hi @raprabhakaran ,

It seems that your customized relevant innovative insights did not return expected result. Could you please share  the pbix file after removing sensitive data to help us clarify your scenario?

In addition, for such data, I'd like to firstly unpivot it 

Refer to:

Use insights to explain increases and decreases in visuals - Power BI | Microsoft Docs

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.