Heatmap

[Chanleakna123]

 

Hi , I would like to create the Heatmap exactly the same , showing the description and number. 
I tried Table Heatmap visual , but is not as expected. 
and I use table visualization , but it's not drop to row number 1 or 2 or 3 . Only keep going straight by using scrolling bar . 
we don't want this, we wanna have the same thing as the visual showing in the picture. 

PS : I have 100 products . So we expect to see every Products by not using scrolling bar to go horizontal , but vertical can scrolled. 

is there any way we can do that. 

[Anonymous]

HI @Chanleakna123,

If you are familiar with R script, you can also try to use R visual to invoke the library to plot these effects:

Heatmap | the R Graph Gallery (r-graph-gallery.com)
Regards,
Xiaoxin Sheng

[Chanleakna123]

Hi @Anonymous  , i know nth on R script . 

Do we have any other solution to acheive this ? 

[amitchandak]

@Chanleakna123 , what I have done for such a display (but I have an index column)

I have taken MOD  and Quotient on a number say 15. And then used them on row and column.

I think scale-based conditional formatting on the measure should work.

[Chanleakna123]

hi @amitchandak  , i'm sorry i don't get you , maybe you can explain more with the sample data ? 
I would love to see that . please 

[amitchandak]

@Chanleakna123 , check the attached file after signature for exmaple. Check Matrix and its duplicate page. Please use your meausre in value.

[Chanleakna123]

@amitchandak  , hi , seems like I need to do measure on Col and row . How to do that ? I also have value measure on %Change VS. LY