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 figure 1 .  are you aware of any visualization or approach to arrive to a similar layout 

 

 

 

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.  

     

4 Replies

  • 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.