Forum Discussion

shazmo2202's avatar
shazmo2202
Regular Visitor
4 years ago
Solved

How do I apply a slicer to a text visual

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 ðŸ™‚

Need Help
Show and Tell
Tips and Tricks

4 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

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

    • shazmo2202's avatar
      shazmo2202
      Regular Visitor
      4 years ago

      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.

      • v-chenwuz-msft's avatar
        v-chenwuz-msft
        Icon for Community Support rankCommunity Support
        4 years ago

        Hi shazmo2202 ,

         

         

        • 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.