Dynamic titles with SSAS Live Connection

[Anonymous]

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!

[v-lili6-msft]

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]

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 · Accepted solution]

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 

[Anonymous]

Thanks @v-lili6-msft for this solution! It worked!