Forum Discussion

mithunt's avatar
mithunt
Frequent Visitor
4 months ago
Solved

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.    Shou...
Need Help
Tips and Tricks
  • Kedar_Pande's avatar
    Kedar_Pande
    4 months ago

    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's avatar
grazitti_sapna
Super User
4 months ago

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!