Reply
WilliamMorenoAE
Regular Visitor
Partially syndicated - Outbound

Conditional Title using Multidimensional Analysis Server as a Source

 

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?

WilliamMorenoAE_0-1604305634162.png

 

8 REPLIES 8
v-janeyg-msft
Community Support
Community Support

Syndicated - Outbound

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.

1.png

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.

Syndicated - Outbound

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.

 

WilliamMorenoAE_0-1604485720137.pngWilliamMorenoAE_1-1604485778760.png

 

Syndicated - Outbound

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
Community Champion
Community Champion

Syndicated - Outbound

@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. 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

Syndicated - Outbound

Hi @negi007 ,

 

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

amitchandak
Super User
Super User

Syndicated - Outbound

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Syndicated - Outbound

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
Regular Visitor

Syndicated - Outbound

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

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)