Treemap Chart

Previous Member

Hi all,

I created treemap chart and I have only one data cube and one axes.I just wanna see my cube's values on my treemap screen like ;

 

But on board; I couldn't add my measure's value inside my treemap charts;

Can anyone explain how can i add my values on the screen,

Many thanks,

Evin.

Paul Wyatt

Hi Evin,

 

Short answer - it can't be done easily.

 

I am assuming that you took your first image from Excel or Power BI?  Unless it has been improved in 10.5, which I cannot test at this moment, the only way to see the figures in BOARD, and any other analysis on entity members, is to hover over the member and read the pop-out details.

 

Below is an image of a dataview.  The tree map below has been created from the layout of the dataview.  Hovering over a sector of the tree map causes the pop-out to appear with the details from the dataview layout to be seen for that sector.

 

 

Image 2: Dataview layout:

 

 

WORK-A-ROUND

If it were imperative to show the values within the tree map, I would recommend creating a parent entity to the one being shown which incorporates in the description, the values of the member being shown.  This would become cumbersome and limiting to slice and dice but I do not know your exact use case scenario and so this may or may not be feasible.

 

In brief, the process would require the following:

 

1. 1 x Parent Entity related to axis entity.
2. 1 x procedure:
   1. EXTRACT the dataview layout
   2. Import DESCRIPTION of parent entity members to be a compound of entity member & the required value

                  eg: Member [Acme co] & value [123 ft²] = Acme Co - 123 ft²

   3.  Configure screen to run and display tree after each slice/dice action.

 

Evin,  I think you have the makings of an IDEA here for BOARD to consider in future releases so please consider submitting one.  In any case, let me know your thoughts and if I can help in any way to achieve your outcome I will.

 

Kind regards,

 

Paul Wyatt