Conditional Title using Multidimensional Analysis Server as a Source

[WilliamMorenoAE]

How can i set a dynamic value in the title using source field. Im using Multidimensional Analysis Services as a data source. It seems i cannot select anything on the list of fields.

Is there any requirement so i can use my fields as Conditional Formulas?

[v-janeyg-msft]

Hi, @WilliamMorenoAE 

It’s my pleasure to answer for you.

According to your description, Can you tell me how do you want to dynamically display the field?

Here is my sample file.Hope it helps.

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[WilliamMorenoAE]

Hi @v-janeyg-msft,

Your solution is based on the axis and slicer. 

My question is how can we use Dynamic Title in the charts, table, matrix using the Dimension Field Value. We are currently using Multidimension Cube as a source.

It seems that we cannot select anything in the list of fields (see my first screenshot) even we expand it everything in the list is greyed out and seems we cannot use the field as Dynamic Title.

[v-janeyg-msft]

Hi, @WilliamMorenoAE 

If you can't select anything in the list of fields,I think it should be caused by your connection mode.Live connection has some functional limitations.If you can, try the import mode.If you can’t change it, you can try not to display the title and use cards and other forms.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[negi007]

@WilliamMorenoAE Did you try using Rules instead of Field Value. You should be able to select the measure that you wish to use for conditional formatting. 

[WilliamMorenoAE]

Hi @negi007 ,

Thanks! do you have sample or reference that i can use for that? 

[amitchandak]

@WilliamMorenoAE , You should be able to search and select a measure , Open the folder and select a measure or column

[WilliamMorenoAE]

Hi @amitchandak, Thanks i was able to expand the list of measure and dimension but i cannot select anything in the list. Do you know what data type i need in my Multidimensional Cube Dimension in order to use it as conditional title expression in the chart?

[WilliamMorenoAE]

By the way we are using live connection in SSAS source. Thanks