Forum Discussion
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!
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 π‘
5 Replies
- DataVitalizer
Super User
Hi Subliminal01
I suggest using a Matrix Visual with Conditional Formatting (Heatmap Style)
- Insert a Matrix visual
- 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)
- 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- Subliminal01Regular 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
Super 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 π‘
- Subliminal01Regular Visitor
works now, thanks a lot!