https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Heat-map-or-scatter-plot/m-p/3076196#M6853 <P>Dear community, I am trying to create a heat map for the fields that I have in my datasource. I have fields like customername, Rate of INterest, Risk Type etc. I want to show bubbles for all customers who are below and above average. I would also would to show an average line showing which customers are falling above and below average.</P><P>&nbsp;</P><P>I have created below 2 additional columns but they are not appearing in the table.&nbsp;</P><LI-CODE lang="markup">Average Rate of Interest = AVERAGE('Company Data'[Rate Of Interest]) Above/Below Average = IF('Company Data'[Rate Of Interest] &gt; 'Company Data'[Average Rate of Interest], "Above Average", "Below Average")</LI-CODE><P>&nbsp;I am very new to Power BI. Can someone guide me with the steps to achieve.</P> Sat, 11 Feb 2023 18:22:03 GMT vaibhavk87 2023-02-11T18:22:03Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Heat-map-or-scatter-plot/m-p/3076196#M6853 <P>Dear community, I am trying to create a heat map for the fields that I have in my datasource. I have fields like customername, Rate of INterest, Risk Type etc. I want to show bubbles for all customers who are below and above average. I would also would to show an average line showing which customers are falling above and below average.</P><P>&nbsp;</P><P>I have created below 2 additional columns but they are not appearing in the table.&nbsp;</P><LI-CODE lang="markup">Average Rate of Interest = AVERAGE('Company Data'[Rate Of Interest]) Above/Below Average = IF('Company Data'[Rate Of Interest] &gt; 'Company Data'[Average Rate of Interest], "Above Average", "Below Average")</LI-CODE><P>&nbsp;I am very new to Power BI. Can someone guide me with the steps to achieve.</P> Sat, 11 Feb 2023 18:22:03 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Heat-map-or-scatter-plot/m-p/3076196#M6853 vaibhavk87 2023-02-11T18:22:03Z