Creating matrix visual with certain values having a different formula

Question

Hi everyone&nbsp;I have created a matrix visual in the below formatService LineHoursRevenueCostRPHCPHCategory 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Actual6136311138596102.954362.96248Budget1741284703968516.3526722.79437Estimate741274703868537.0715252.20648Forecast1354905817728166.8988257.07607Variance387-62111-37596zzzzzzzzCategory 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Actual&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Budget&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Estimate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Forecast&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Variance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Category 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Actual&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Budget&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Estimate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Forecast&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Variance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;RPH = Revenue / HoursCPH = Cost / HoursVariance = Budget - Forecast&nbsp;The rows Actual, Estimate, Budget, Forecast and Variance is coming from the table loaded via PowerQuery and hence all calculations are done in powerquery and it comes correctly. RPH and CPH are measures. Hence, when it comes to Variance of the measures RPH and CPH, the answer would be incorrect in those two highlighted cells.&nbsp;Is there a way to make amendments to those two cell calculations alone?

bastianki · Answer

Hello allI could tweak the settings by conditionally formatting the last two columns for all rows where Variance appears - I made the font color same as background color and made it invisible.&nbsp;Is there any other alternate solution available.?&nbsp;

Forum Discussion

Creating matrix visual with certain values having a different formula

1 Reply

Related content

Different schema into different destination

How to avoid people creating multiple times the same table in different workspaces

Create a report per Worker ID with different datasets feeding different tablix

Creating relationships

Creating ICMs via Activator

Service Line	Hours	Revenue	Cost	RPH	CPH
Category 1
Actual	613	63111	38596	102.9543	62.96248
Budget	1741	28470	39685	16.35267	22.79437
Estimate	741	27470	38685	37.07152	52.20648
Forecast	1354	90581	77281	66.89882	57.07607
Variance	387	-62111	-37596	zzzz	zzzz
Category 2
Actual
Budget
Estimate
Forecast
Variance
Category 3
Actual
Budget
Estimate
Forecast
Variance