Forum Discussion
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-msftCommunity 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
- AnonymousNot 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-msftCommunity 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