Dynamic Chart titles from Power BI live connection and SSAS cube as the data source

[YellaReddy]

Hi All,

Facing an issue with dynamic chart title names based on the filter conditions(From slicer) in the Power Bi live connection(From SSAS cube).

In the chart visualizations->General->Title->Conditional Formatting->Title-Text->Format Style(Selected as Field Value)-> What field should we base this on?.

Under this "What field should we base this on" all the options are "grid out". I could n't able to select any measure or dimension in the list.

Could some one assist on this please? Also any alternative to implement dynamic titles in the chart based on the filter selection.

I have implemented the dynamic chart title, Excel as source and it is working fine.

Thak you for your help in advance.

Regards

Yella Reddy

[CracktheCode85]

How do you create a measure on a Live Connection to Cube data that is seemingly "locked" from any type of adjustments?

[v-chenwuz-msft · Accepted solution]

Hi @YellaReddy ,

You need create a measure which returns the string as the title text.

For example

Measure: 

SWITCH(SELECTEDVALUE(financials[Year]),2013,"2013 - all countries sales",2014," 2014 - all countries sales","2013 - 2014 All Countries Sales")

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.