Forum Discussion
Remove empty row headers from matrix
Dear PowerBI experts, I hope one of you has a solution to the following. I am building a P&L report. The rows are derived from a multi-level account hiearchy where level 1 is the highest lev...
There is an excellent video here: https://www.youtube.com/watch?v=W4zEYkDC3Tw that shows how to handle displaying hierarchical data in the context of a P&L statement. The part that specifically addresses your issue is at 40:00 minutes, but you will likely need to watch the entire video for context.
NOTE: Refer to Matt's website at https://exceleratorbi.com.au/build-a-pl-with-power-bi/ where he provides the DAX formulas, which are slightly different than exactly what he used in the video, and worked better for my application.