Forum Discussion
abc_777
Solution Specialist
Solution SpecialistTotal cell hide
Hi I want to show the value for Total for actual Quantity measue - 17.50 KG but want to hide Total for total Sales Measure - 31,806.25
abc_777 ,
You can use the HASONEVALUE function as below,
SkipTotal = IF(HASONEVALUE('Date Dim'[Month_Year]),'Measure Table'[Lasgt_6_months_Sales],blank())
abc_777Solution Specialist
Solution Specialistcan you help me with detail steps please
AliceW
Power Participant
Power ParticipantGot you covered, abc!
So, in the Desktop version, you click on the table.
Then, you go to 'Field Formatting'.
You select the column you want.
Then, 'Font color', select white.
Then, 'Apply to totals', and NOT to header and values.