Visualization Challenge

[cg1980]

Hi Team, 

I Need to create a Heat Map (Figure 1) , My data looks like the table below..(Figure 2)  its easy to show the data within a matrix but im looking something more appelaing and close to figure 1 .  are you aware of any visualization or approach to arrive to a similar layout 

[cg1980]

Hi Miguel!,  sounds like an option, but  i need to have the column names below and the "Status" hiden to represent exactly the matrix as in my screen, users are use to that and i can not changer..  do you see any workaround? all the best,  

[MFelix]

Hi @cg1980 ,

Using the Matrix visualization you can do the following:

• Create a measure:

Values for Table = IF(ISINSCOPE('Table'[Status]), SUM('Table'[Value]), MAX('Table'[Importance]))

• Place the measure on the matrix and make the column headers blank.

You can also try to use a custom chart from charticulator:

https://charticulator.com/app/index.html

If you want I can try and build one and guide you trough.

[Anonymous · Accepted solution]

Not ideal (because too many visuals take a while to load), but in the past, I have used conditional formatting on card visuals, to create something similar, with text boxes as headers.  

[MFelix]

Hi @cg1980 ,

I now you have refered the matrix visualization but have you tried it out with the condittional formatting applied to it?