topic Re: Missing column and Row Values in heatmap in Custom Visuals Development Discussion https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Missing-column-and-Row-Values-in-heatmap/m-p/2930894#M6289 <P>Please provide sanitized sample data<STRONG> that fully covers your issue</STRONG>.<BR />Please show the expected outcome <STRONG>based on the sample data you provided</STRONG>.</P> Sat, 26 Nov 2022 22:55:23 GMT lbendlin 2022-11-26T22:55:23Z Missing column and Row Values in heatmap https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Missing-column-and-Row-Values-in-heatmap/m-p/2929708#M6283 <P>Hello everyone,</P><P>I am facing the problem of missing columns and rows in the heatmap.</P><P>I have 8 categories for which I need to draw the heatmap.</P><P>Let's say they are A B C D E F G H</P><P>&nbsp;</P><P>I can only create the following</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D</P><P>B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4</P><P>D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6</P><P>&nbsp;</P><P>&nbsp;</P><P>Because there are no other existing values for the other columns/rows, and they don't show up.</P><P>I want to make my heatmap look like the one below despite having no values for the others and filling them up with 0</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;E&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; G&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; H</P><P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P><P>B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;.................&nbsp;&nbsp;</P><P>C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ........</P><P>D</P><P>E&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Zeros everywhere here</P><P>F</P><P>G</P><P>H</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P><P>How can I show the heatmap like this?? Thanksss</P><P>&nbsp;</P><P><STRONG>Edit:&nbsp;</STRONG> Problem was solved by just adding the measure I wrote by 0 . Like A[X] + 0 . Thanks</P> Mon, 28 Nov 2022 08:11:04 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Missing-column-and-Row-Values-in-heatmap/m-p/2929708#M6283 Anonymous 2022-11-28T08:11:04Z Re: Missing column and Row Values in heatmap https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Missing-column-and-Row-Values-in-heatmap/m-p/2930894#M6289 <P>Please provide sanitized sample data<STRONG> that fully covers your issue</STRONG>.<BR />Please show the expected outcome <STRONG>based on the sample data you provided</STRONG>.</P> Sat, 26 Nov 2022 22:55:23 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Missing-column-and-Row-Values-in-heatmap/m-p/2930894#M6289 lbendlin 2022-11-26T22:55:23Z