Solved: How do I apply a slicer to a text visual

shazmo2202 · ‎03-23-2022

Hi folks,

I'm new to using Power BI and have come across an issue that I'm hoping you can help me with.

I've created a report for our UK business unit and have added a slicer to allow the department heads to view the visuals for their respective departments.

Is there a way I can get the slicer applied to change text I have in a text visual so that it only shows the commentary relevant to what has been selected on the slicer?

I saw from a previous post on the forum that it was best to have a separate table with the commentary in it which is how I have set the report up but I'm struggling to get the slicer to apply to the text visual despite there being common columns in all tables.

Appreciate any advice/suggestions. Thanks in advance 🙂

v-chenwuz-msft · ‎03-28-2022

Hi @shazmo2202 ,

Smart narratives

You can use the measure as the value in the text box. Please refer this screenshot.

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

lbendlin · ‎03-24-2022

Read about Smart Narratives - that is text that can be influenced by filters.

shazmo2202 · ‎03-25-2022

Thanks so much for your suggestion. I truly didn't know where to look for ideas on how to do this and my Google searches to date haven't been successful.