Forum Discussion
NLP Visual
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?
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
4 Replies
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!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
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.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.
