Forum Discussion

venug20's avatar
venug20
Resolver I
8 years ago
Solved

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

Need Help
  • Thejeswar's avatar
    Thejeswar
    8 years ago

    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 Expanded

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

     

    Switch off stepped layout

    3.  Modify the Row Subtotals as shown below

    Modify the Row SubtotalsYour Output will look like the one below

     

     

     

5 Replies

  • Thejeswar's avatar
    Thejeswar
    Super User
    8 years ago

    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 Expanded

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

     

    Switch off stepped layout

    3.  Modify the Row Subtotals as shown below

    Modify the Row SubtotalsYour Output will look like the one below

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
    prihana
    Helper V
    8 years ago

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

    • venug20's avatar
      venug20
      Resolver I
      8 years ago

      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....

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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