Forum Discussion

cg1980's avatar
cg1980
Helper 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
Helper 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
    Super 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.