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())
AliceW
Power Participant
Power ParticipantUse the column format! Choose to display the total (and not the title and values) in WHITE. Boom, you have an invisible total. Not fancy, but it works for me!
- abc_777
can you help me with detail steps please
- AliceW
Got 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.