Forum Discussion
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...
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
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