Forum Discussion
Customizing the row subtotal for a single column
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?
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]))
2 Replies
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]))Thanks, the second fix worked best, the other created some hierarchy in the rows that I wasn't too happy with. Thanks!
