Forum Discussion

Subliminal01's avatar
Subliminal01
Regular Visitor
1 year ago
Solved

Not able to find a heatmap

Hi, i am new here, just trying out different things

 

Could someone help me with a heatmap visual?
I have multiple (0, 1) on x and y-axes, and I thought of creating a heatmap for it, as it seemed the best option, but there is no heatmap visual for a non-corporate account, how can I describe the above sceanrio using some other visual or maybe use a heatmap if it is somewhere

 

Thanks!

  • DataVitalizer's avatar
    DataVitalizer
    1 year ago

    Hi Subliminal01 


    Exactly, the cell's color will adjust based on its value (either 0 or 1).

     

    If you have a sample, it would greatly aid in better understanding the intended outcome.

    Did it work? πŸ‘ A kudos would be appreciated
    🟨 Mark it as a solution to help spread knowledge πŸ’‘

     

    🟩 Follow me on LinkedIn

5 Replies

  • Hi Subliminal01 

     

    I suggest using a Matrix Visual with Conditional Formatting (Heatmap Style)

    1. Insert a Matrix visual
    2. Drag:
      • Your X field to Columns
      • Your Y field to Rows
      • A count measure (or whatever you're tracking) to Values
        (e.g., Count of ID or Sum of something)
    3. Apply conditional formatting to the Values field:
      • Click on the field in Values β†’ Conditional formatting β†’ Background color
      • Choose color scale to mimic a heatmap

     

    This gives you a grid where higher values appear in darker colors just like a heatmap.


    Did it work ? πŸ‘ A kudos would be appreciated β€Œβ€ŒπŸ“’ Mark it as a solution to help spreading knowledge

    • Subliminal01's avatar
      Subliminal01
      Regular Visitor

      yeah but this just adds colors, giving it the look of a heatmap
      but I want to represent data which has (0,1) on each axes, sort of a confusion matrix

      • DataVitalizer's avatar
        DataVitalizer
        Icon for Super User rankSuper User

        Hi Subliminal01 


        Exactly, the cell's color will adjust based on its value (either 0 or 1).

         

        If you have a sample, it would greatly aid in better understanding the intended outcome.

        Did it work? πŸ‘ A kudos would be appreciated
        🟨 Mark it as a solution to help spread knowledge πŸ’‘

         

        🟩 Follow me on LinkedIn