NLP Visual

[mithunt]

Hello Powerbians

I need some guidance here to understand if I can have a Visual where I give users the option to select the narrative and the Narrative displays information in Power Bi. 

Should be like 

Options - 

1. Sales by Product - Explains the sales by product, which product has highest or lowest sales, how is the trend , etc.,

2. Orders by Country - A narrative which tells insights about the orders

As user clicks each of the option, the narrative should change .

Can this be achieved in Power BI?

[v-karpurapud]

Hi @mithunt 

We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank You.

[v-karpurapud]

Hi @mithunt 

Thank you for submitting your question to the Microsoft Fabric Community Forum. Thanks also to @grazitti_sapna  and  @Kedar_Pande  for providing helpful suggestions.

I hope the information shared helps resolve your issue. If you have more questions or need further assistance, please let us know. We're here to help.

Best regards,
Community Support Team.

[Kedar_Pande · Accepted solution]

@mithunt 

Add Smart Narrative visual

Slicer on narrative type (Sales by Product, Orders by Country)

Narrative Text = 
SWITCH(
SELECTEDVALUE(Narrative[Type]),
"Sales by Product", 
"Top product: " & 
MAXX(TOPN(1, Products, [Sales]), Products[Name]) & 
" (" & FORMAT([Sales], "#,0") & ")",
"Orders by Country", 
"Highest orders: " & 
MAXX(TOPN(1, Countries, [Orders]), Countries[Name]),
"Select narrative"
)

Text box → fx → Narrative Text

[grazitti_sapna]

Hi @mithunt,

Yes, you can acheive it by creating a separate filter table and using it in the calculation.

I've created a sample .pbix file for you, you'll get the idea and can alter as per the requirements.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!