Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic titles with SSAS Live Connection

Hi community,

I'm trying to use the Conditional Formatting on a visual title with a measure containing a "SELECTEDVALUE". But the problem is that I can't select this measure in the Conditional Formatting title window when I use the SSAS "Live Connection" datasource, it appears grayed (unclickable). If I choose the "Import" method, the same measure works perfectly in the title, I can choose it in the list.

So am I doing something wrong or is it the normal behavior? If it is, I don't understand why it is not possible to do this when I use Live Connection instead of Import, because creating measures is allowed in both methods.

Thank you!

  • hi, Anonymous 

    Please check the format in AS model, and you could try to add a new measure in power bi use the same formula.

    Dynamic title = "Some text " & SELECTEDVALUE([City_Name];"All cities") & " some text"

     

    Best Regards,

    Lin 

4 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support

    hi, Anonymous 

    Expression bound titles right now work only on text measures. 
    Please check the format of this measure if it is text.

     

    Best Regards,

    Lin

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi v-lili6-msft 

      Thank you for your awnser.

      Yes, my expression contains only text. It looks like this :

      Dynamic title = "Some text " & SELECTEDVALUE([City_Name];"All cities") & " some text"
      • v-lili6-msft's avatar
        v-lili6-msft
        Community Support

        hi, Anonymous 

        Please check the format in AS model, and you could try to add a new measure in power bi use the same formula.

        Dynamic title = "Some text " & SELECTEDVALUE([City_Name];"All cities") & " some text"

         

        Best Regards,

        Lin