Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Remove value name in TOTAL line

I have a table similar to this:

 

Unit #Unit NameUnit Budget

456

First$100
123Second$200
789Third$300
TotalSecond$600

 

I don't want the Second unit name (red for emphasis) showing up in the total row. I just want this space to blank.

I've checked numerous formatting options but I still can't get the name to disappear. Any suggestions?

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Under Totals in the format pane while clicking on your table. Make the font color and background color white.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Sure, you can use a measure like Anonymous suggested but you can simply just format the total label like I did. Please accept this as a solution if it helped!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi  Anonymous ,

     

    Whether [Unit Name] is a measure or not, if you just want the Total line of [Unit Name] to be blank and the rest of the Total lines to be unchanged, you can experiment with the IF()+HASONEVALUE () function.

    Refer to:

    IF function (DAX) - DAX | Microsoft Learn

    HASONEVALUE function (DAX) - DAX | Microsoft Learn

    Create measure.

    Measure_Unit Name =
IF(
    HASONEVALUE('Table'[Unit #]),
    [Unit Name],BLANK())

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly