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

Need Help

4 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    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: [email protected]

    Best Regards,
    Angelia

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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).

      • 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