Customizing the row subtotal for a single column

[Pascal_15]

Hi,

I have searched for this and there should actually be a simple solution to this however it is not showing up as an option in my Power BI. So either Im doing something wrong or it's not available anymore.

I have a table showing when budget changes have been requested, that table also contains a date field:

The 'Actueel' line is a Row subtotal. It shows the initial budget (PVA) and changes that have been requested (WV1/2). It also shows when these documents have been submitted. Preferably I would just like to keep the subtotal for the date field empty as its nonsense. 

For some reason Power BI doesn't recognize anything but the 'Wijziging' column as a column and is not giving me an option to change it:

I was hoping to just be able to select the date column here and change the text color or whatever to make it disappear. Any tips?

[miTutorials · Accepted solution]

You can fix this in 2 ways..

1. Move the Date field to 'Rows' instead of 'Values'

2. Create a measure like below and drag the measure to Values section.

Date = IF(ISINSCOPE('Table'[Wijziging]),MAX('Table'[Date]))

[Pascal_15]

Thanks, the second fix worked best, the other created some hierarchy in the rows that I wasn't too happy with. Thanks!