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())

     

AliceW's avatar
AliceW
Power Participant
4 years ago

Use 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'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.