Subtotals by Data Group
This is ny first day with Power BI. I am trying to create a band that will give a subtotal of product prices for each category. I find the Table Wizard to be unsuitable for what I am doing. i.e. I want the products listed by category then a subtotal of the prices for each category. I have created a table that will show the columns of interest but I can see how to do the Category Subtotals.
Relative Positioning on Shapes Changing Based on Resolution
I'm trying to create a sort of dynamic PNL using the basic matrix visualization. The issue is that I want subtotals for each of the bolded catergories, and then a grand total (Net Income). I've created a matrix that functions properly, but there are extra lines of data that repeat catergory sums. In order to negate this issue, I placed grey shapes over the unwanted rows to hide them. The issue is that when I view the report on screens of different resolutions, the shapes move slightly. This movement will cause the shapes to be covering the wrong rows of data. Is there any way to either A) lock the shapes in place relative to the matrix or B) insert custom subtotal rows in a matrix? Attached is a screenshot of the first column of this matrix, with the shapes in place below "Total Utilities" and "Taxes & Insurance"PowerBI matrix show rowlevels dynamically
Hello, I am using a tablematrix in PowerBI with 6 rows and 7 values. I present this in the matrix with a Stepped layout. See the first example. As you can see, there are 5 levels to expand to. Basicly there are 6 but in this example, I show only 5. As you can see in the second example, on level 5 (and 6) is the row empty except for the 6th and 7th column. Is there a possibility within PowerBI to hide this level 5 blank row and show only the subtotals? So when expanding to a next level, show only if there is information on row level. Otherwise, show only the subtotals but in combination with rows that contain information.
