Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
4 years ago
Solved

Total 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     
Need Help
  • Aburar_123's avatar
    Aburar_123
    4 years ago

    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_777's avatar
abc_777
Solution Specialist
4 years ago

can you help me with detail steps please

AliceW's avatar
AliceW
Power Participant
4 years ago

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.