Forum Discussion
Dynamic Title based on dimension that is not selected
Here is my full data model:
Here is a zoom in on the part of it related to my question:
Here is the report I am trying to create:
On the left is a slicer that has Client Name and Program Name. Once a program is selected, it limits the facts to just that program. There are nine pie charts that summarize the field FactValue from ResponseFacts. The OptionValue comes from the MultiSelectOptions table. Each visual has a filter on the RubricCategories Sequence field. The fist one selects Sequence of 1, the second one selects a Sequence of 2, and so on. I want to set the title of each visual to be the corresponding Label column from Rubric Categories. But nothing I have done seems to give me this. It seems to select a random value from that table.
Does that help?