Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic Titles

Not sure if this is me (I am only about 1 year into my PBI journey) or if PBI is still a bit buggy sometimes

I have a shape map of US grouped into Sales Regions (Territory)

If I click 'Territory' in the shape map (Legend) - all good. If I click a 'State' in the shape map - also good

DAX measures for 'Selected Metric', 'Selected Territory', 'Selected State' (SELECTEDVALUE) work OK (see image attached)

 
Territory Title = COMBINEVALUES(" ",[Selected Metric] & " Analysis for",[Selected Territory] & " " & [Selected State]) - OK when displayed on a card. As Shape Map -> Title Text -> Field Value -> Based On -> 'Territory Title' ... does not update
 
Does anyone have any ideas?

 

 

Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    I know where the problem is. When you interact with the shape map, the card will be updated, but the custom title will not be updated.

     

    You can use the slicer to filter the Territory and State so that the custom title will also be updated.

     

    But the current version(2.92.706.0 64-bit (April 2021)) is impossible to change the custom title by interacting with the visual. Or you can submit an idea .

     

    Best regards,
    Lionel Chen

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

     

5 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, Anonymous 

    Please correct me if I wrongly understood your data model.

    I am not sure, but I think the Map Visualization is not filtered by the state and territory. So, that is why the map is showing all territories and all states. Please correct me if I misunderstood.

    Thanks.

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Jihwan, selected territory is Southeast & selected state is Florida

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    I know where the problem is. When you interact with the shape map, the card will be updated, but the custom title will not be updated.

     

    You can use the slicer to filter the Territory and State so that the custom title will also be updated.

     

    But the current version(2.92.706.0 64-bit (April 2021)) is impossible to change the custom title by interacting with the visual. Or you can submit an idea .

     

    Best regards,
    Lionel Chen

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks Lionel, basic idea was that user could click on a state to slice. Workaround by adding a card as page title rather than a text box, so 24pt obvious what they are looking at. Works out OK for matrix, bar chart & line chart, just not for shape map ... OK, I understand shape map is in beta & version 1 of something is never the final version.

      • v-lionel-msft's avatar
        v-lionel-msft
        Community Support
        5 years ago

        Hi Anonymous ,

         

        Yes, your suggestion is very good, so that the idea is realized at least to a certain extent.

         

        Best regards,
        Lionel Chen

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