Forum Discussion

cg1980's avatar
cg1980
Icon for Helper I rankHelper I
5 years ago
Solved

Visualization Challenge

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 figu...
General Comment
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.  

     

cg1980's avatar
cg1980
Icon for Helper I rankHelper I
5 years ago

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's avatar
MFelix
Icon for Super User rankSuper User
5 years ago

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.