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...
  • Kedar_Pande's avatar
    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