topic Re: Matrix Heat in Desktop

Matrix Heat

Anonymous — Fri, 07 Oct 2016 05:07:29 GMT

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 drag dimensions in columns and lists and one measure in the intersection.?

Re: Matrix Heat

v-huizhn-msft — Tue, 11 Oct 2016 01:15:17 GMT

Anonymous As I tested, we can only put single measure in Table Heatmap. It seems to be a limitation. And it’s not supported to convert its table into matrix. I suggest you contact the author: galiya@galiya.info

Best Regards,
Angelia

Re: Matrix Heat

Anonymous — Tue, 11 Oct 2016 09:31:45 GMT

but i am able to put more than one measure in table heat map, only limitation is i am unable to use it as matrix (tow dimension one as rows and another one as column and a single measure as intersection values).

Re: Matrix Heat

v-huizhn-msft — Wed, 26 Oct 2016 04:52:09 GMT

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 galiya@galiya.info.

Thank you very much.

Best Regards,
Angelia

Re: Matrix Heat

Anonymous — Wed, 26 Oct 2016 07:21:39 GMT

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.