https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/KPI-Matrix-3-1-1-KPI-Indicator-non-tabular-data/m-p/3247525#M7565 <P>I was studying the Pbix sample file but still couldn't figure out how to create KPI Indicator for my case.</P><P>So in the sample file, the data is in the tabular form like pic below so it's very easy to calculate the variance and hence, the KPI Index. (calc variance = actual value/target - 1)</P><P><img /></P><P>My data, however, looks like this.</P><P><img /></P><P>So the Actual and Budget for Vol, Rev, NB here is the calculated fields. PowerBi then calculates the KPI comparing Actual vs Budget "Actual vs Budget%". So how can I create a KPI Indicator for the "Actual vs Budget%" field indicating negative = red color and positive = green color?</P><P>&nbsp;</P><P>Thank you.</P> Mon, 22 May 2023 12:27:11 GMT my_microsoftacc 2023-05-22T12:27:11Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/KPI-Matrix-3-1-1-KPI-Indicator-non-tabular-data/m-p/3247525#M7565 <P>I was studying the Pbix sample file but still couldn't figure out how to create KPI Indicator for my case.</P><P>So in the sample file, the data is in the tabular form like pic below so it's very easy to calculate the variance and hence, the KPI Index. (calc variance = actual value/target - 1)</P><P><img /></P><P>My data, however, looks like this.</P><P><img /></P><P>So the Actual and Budget for Vol, Rev, NB here is the calculated fields. PowerBi then calculates the KPI comparing Actual vs Budget "Actual vs Budget%". So how can I create a KPI Indicator for the "Actual vs Budget%" field indicating negative = red color and positive = green color?</P><P>&nbsp;</P><P>Thank you.</P> Mon, 22 May 2023 12:27:11 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/KPI-Matrix-3-1-1-KPI-Indicator-non-tabular-data/m-p/3247525#M7565 my_microsoftacc 2023-05-22T12:27:11Z