How do I group columns by category in the same pivot table in excel?
Good afternoon guys, what's up? I need some help I'd like to layout the PowerBi "Matrix" in the same way that the "Pivot Table" groups the categories before showing the value, as shown in the photos below. 1. Excel - Pivot Table In the image below we can see that the pivot table first categorizes the values - Volume/Weight and Volume Measure - before grouping by BAT/PMI and JTI 2 - Power BI - Matrix In Power BI, the "Matrix" does just the opposite, first it categorizes BAT/PMI/JTI and then it categorizes the values I would like to know if it is possible to visualize the "Pivot Table" (example of photo 1) in PowerBI with "Matrix"?
Matrix Grouped Column issue: Columns are appearing with Gap in between.
Hi, I'm working on a Power BI paginated report. I have a Matrix with a column group. This Matrix has three parent groups. Grouped columns are dynamic as its number of columns can increase or decrease based on its parent groups. This metrix is to be replicated for multiple times based on the iteams selected in the parameters. Now because based on parent groups all columns will not be a part of each replication on matrix. Example: Prt Group1 -- Prt group2-- Prt group3--Matrix with 3 columns, Prt Group1 -- Prt group2-- Prt group3--Matrix with 6 columns, Prt Group1 -- Prt group2-- Prt group3-- Matrix with 4 columns Now when data is displayed in report Columns are not staring from the 1st place from where column1 should started instead, if it is on the 5th place or as per the auto sort; is starting from nth place having first few column space as blank. These few blank space are left because in same report's another set of matrix replication will have those few columns which are not part of first matrix replcation. Similarly in each set of data displayed in the matrix columns are getting spread out. Ex: Parent group 1 Parent group 2 Parent group 3 (Set 1) Metrix Data: Gap Gap Column1 Column2 Column3 Column4 Column5 data data data data data Parent group 1 Parent group 2 Parent group 3 (Set 2) Metrix Data: Column1 Column2 Gap Gap Gap Column3 Column4 Column5 Column6 Column7 data data data data data data data I would like to know how to start each column from its first place in each set with out any gap. Please suggest can this be achieved in Power BI paginated report? Thank you for time.
