Forum Discussion
AI Text Analytics fields returned
Hi Anonymous ,
Azure will take a swift amount of time and create a new column named CognitiveServices.ScoreSentiment which now contains the sentiment value of the news. This was performed by the use of the Azure Cognitive Services - Score Sentiment feature which is integrated into the premium version of Power BI. Here, in the backend, the Power BI will make an API call by itself to Azure Cognitive Services Text Analysis Model which will return the Score Sentiment value on the Power BI automatically.
As we can see, the values are between 0 and 1.
The closer the Sentiment value is to 1- it can be recognized as more Positive News and the closer the sentiment of the news is to 0, it can be understood are more negative.
You could add a Conditional Column to make this outcome more intuitive.Suppose if the sentiment value is above 0.5 the News is Positive, 0.5 precise as Neutral and below 0.5 as Negative.
Refer to:
A CLOSER LOOK AT TEXT ANALYTICS (SCORE SENTIMENT) IN POWER BI DESKTOP
SENTIMENT ANALYSIS IN POWER BI DESKTOP
Azure Text Analytics and Power BI
Power BI Tutorial - Sentiment Analysis
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.
Hi Anonymous ,
Azure will take a swift amount of time and create a new column named CognitiveServices.ScoreSentiment which now contains the sentiment value of the news. This was performed by the use of the Azure Cognitive Services - Score Sentiment feature which is integrated into the premium version of Power BI. Here, in the backend, the Power BI will make an API call by itself to Azure Cognitive Services Text Analysis Model which will return the Score Sentiment value on the Power BI automatically.
As we can see, the values are between 0 and 1.
The closer the Sentiment value is to 1- it can be recognized as more Positive News and the closer the sentiment of the news is to 0, it can be understood are more negative.
You could add a Conditional Column to make this outcome more intuitive.Suppose if the sentiment value is above 0.5 the News is Positive, 0.5 precise as Neutral and below 0.5 as Negative.
Refer to:
A CLOSER LOOK AT TEXT ANALYTICS (SCORE SENTIMENT) IN POWER BI DESKTOP
SENTIMENT ANALYSIS IN POWER BI DESKTOP
Azure Text Analytics and Power BI
Power BI Tutorial - Sentiment Analysis
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.
Thank you.
So there's no way to return the same azure sentiments (ideally, "mixed" with the combination of phrases) in Power BI?
Is it accurate then to do the exact values as you specified:
< 0.5 = negative
=0.5 = neutral
>0.5 = positive