cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
venug20
Resolver I
Resolver I

Display data in matrix Visual like tabular format

Hi Every one,

 

I have raw data like below

 

Row LabelsSub-CategorySum of Sales
FurnitureBookcases1522871.988
FurnitureChairs1681154.762
FurnitureFurnishings442367.4739
FurnitureTables878768.6674
Office SuppliesAppliances1080041.552
Office SuppliesArt386915.9419
Office SuppliesBinders584382.8757
Office SuppliesEnvelopes179012.7656
Office SuppliesFasteners85060.0439
Office SuppliesLabels80092.486
Office SuppliesPaper292648.3314
Office SuppliesStorage1255552.179
Office SuppliesSupplies273401.2066
TechnologyAccessories851079.1045
TechnologyCopiers1621935.071
TechnologyMachines878511.6281
TechnologyPhones1891126.685
Grand Total 13984922.76

 

 

 

and i want to show data in power bi like below...

 

Row LabelsSub-CategorySum of Sales
FurnitureBookcases1522871.988
 Chairs1681154.762
 Furnishings442367.4739
 Tables878768.6674
Office SuppliesAppliances1080041.552
 Art386915.9419
 Binders584382.8757
 Envelopes179012.7656
 Fasteners85060.0439
 Labels80092.486
 Paper292648.3314
 Storage1255552.179
 Supplies273401.2066
TechnologyAccessories851079.1045
 Copiers1621935.071
 Machines878511.6281
 Phones1891126.685
Grand Total 13984922.76

 

Can anyone help on this...

 

Thanks in advance....

 

Regards

Venu

1 ACCEPTED SOLUTION
Thejeswar
Resident Rockstar
Resident Rockstar

Hi @venug20,

Do the following to achieve what you want

 

1. Add both Row Labels and Sub-Category to Rows and Expand

 

Matrix with Rows ExpandedMatrix with Rows Expanded

2. Switch off the Stepped Layout option as shown in the pic below 

 

Switch off stepped layoutSwitch off stepped layout

3.  Modify the Row Subtotals as shown below

Modify the Row SubtotalsModify the Row SubtotalsYour Output will look like the one belowmatrix.PNG

 

 

 

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

SImilar to the original question, I have a matrix control showing like this with the name in the rows on the left

 

NameSales PurchasesTotal
Multi Manager500200700
High Income Growth300400700
Growth & Income 100300400
Next Generation300300600

 

I would like to flip the table by transposing the matrix so that the name in the rows above are now shown in the columnss at the top and the numbers go across instead of downwards like in the table below.

 

NameMulti ManagerHigh Income GrowthGrowth & Income Next Generation
Sales 500300100300
Purchases200400300300
Total700700400600
Thejeswar
Resident Rockstar
Resident Rockstar

Hi @venug20,

Do the following to achieve what you want

 

1. Add both Row Labels and Sub-Category to Rows and Expand

 

Matrix with Rows ExpandedMatrix with Rows Expanded

2. Switch off the Stepped Layout option as shown in the pic below 

 

Switch off stepped layoutSwitch off stepped layout

3.  Modify the Row Subtotals as shown below

Modify the Row SubtotalsModify the Row SubtotalsYour Output will look like the one belowmatrix.PNG

 

 

 

Additonal Solution: If you want to repeat column 1 values then just create the table in matrix, turn off stepped layout,  THEN --> select the matrix and change the visualization type to "Table".  

prihana
Helper V
Helper V

Untitled.png

Add both Type and description under Rows. Click on at the lowest level of data to expand it (grouping by Type)

Hi Prihana,

 

thanks for respond my post,

 

I have already tried, which has provided solution like below... this is known format.... i am asking like above format....

 

 

Pls help any one on my issue....

 

thanks in advance....

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors