- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@WilliamMorenoAE , You should be able to search and select a measure , Open the folder and select a measure or column
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-08-2024 06:41 PM | |||
07-09-2024 04:22 AM | |||
09-15-2024 01:07 AM | |||
08-29-2024 06:18 AM | |||
03-01-2024 07:12 AM |
User | Count |
---|---|
141 | |
117 | |
80 | |
65 | |
47 |