Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Matrix Heat

Is there anyway to use two dimensions in Heatmap? as we are using one dimension and multiple measures in table heat viz, is there any way that we can convert table heat to matrix heat so that we can...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Anonymous

I am very sorry for delay response. Measures can't be used row or column, it can only be values section. Because measures are used in some of the most common data analysis; for example, sums, averages, minimum or maximum values, counts, or more advanced calculations you create yourself using a DAX formula.

For TableHeatMap, it is a third custom visualization, please contract the developer by [email protected].

Thank you very much.

Best Regards,
Angelia

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Anonymous,

You can likely do it with an R visual using only a few lines of code, noting the Known Limitations. I created a sample PBIX, attached as a reply to a very similar sample by fathomson at http://community.powerbi.com/t5/R-Script-Showcase/Heatmaps/m-p/68573  My version uses columns directly from the PBI tables (rather than massage the data with dplyr in R), displays the values for each cell, and has some sample formatting tweaks as well.

 

Matrix Heatmap for Power BI via an R visual