Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic Tooltip Axis

Hello,

 

I am designing a report which shows sales by City. Each City is associated with specific Region -> Country -> Continent.

 

There is a column chart showing aggregated sales value by each month. I want to design a tooltip that will show this value broken down by one of the categories mentioned above (City OR Region OR Country OR Continent). 

 

The user will have a slicer or buttons to choose which level he wants to obtain (City OR Region OR Country OR Continent).

 

What would be the easiest way to achieve a tooltip with a dynamic axis?

 

I was thinking about playing with bookmarks, so the user will select one of the buttons (City OR Region OR Country OR Continent) and this would switch the visual with an appropriate tooltip, but maybe there is an easier way.

 

Thanks!

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Actually I found a solution without bookmarks. I have created a disconnected table where one column has all the values for City AND Region AND Country AND Continent and second column which has a selection value. Next, the second column is used to filter on level of details.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Actually I found a solution without bookmarks. I have created a disconnected table where one column has all the values for City AND Region AND Country AND Continent and second column which has a selection value. Next, the second column is used to filter on level of details.

    • v-xiaotang's avatar
      v-xiaotang
      Community Support
      4 years ago

      Hi Anonymous 

      thanks for your reply.

      if question has been solved, could you mark the answer helpful to close this thread, then the others can find it more quickly. 

      really appreciate!

       

      Best Regards,

      Community Support Team _Tang

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

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi Anonymous 

    you can use slicer + drill through, the limitation is that it is not very dynamic, you need to click on drill button on the visual.

     

    Best Regards,

    Community Support Team _Tang

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