Forum Discussion
Table with all months and value under them
Hi all,
I'm new to PowerBI, I'm coming from Business Objects of SAP. I'm trying to convert all report that I have on old SAP BI to PowerBI. We have all data on Analysis Services.
The issue:
I want to create a table like below:
I chose Matrix like table in visualization an put Customer, Country and Zone under Row. Month under Column.
But in table I see only first value of Row and not others.
Is there a way to see a table like above ?
Thanks
Emiliano74 There are a bunch of formatting options for subtotals under Subtotals in the Format pane. You can turn off row subtotals for example and control column subtotals on an individual basis if you toggle on Per column level.
6 Replies
- Greg_Deckler
Community Champion
Emiliano74 Yes, select your Matrix visualization. Then under Row headers in the Format sub-pane of the Visualizations pane, turn off Stepped Layout. The Format pane is the paint roller icon.
Greg_Deckler if I turn off Stepped Layout nothing happens, but if I turn on "Icon +/-" it appears + before Costumer Name, and if I press on + I can open all value. Is there something like Windows Explorer that I press * to open all + closed ?
- Greg_Deckler
Emiliano74 Those are your drillthrough features you can use the forked arrow icon. Or right click the arrow and expand to next level.
Greg_Deckler can I have sub total only for first value, customer, and not for others ? If yes, how ? Because I see each sub total for each value. Some of these value are unique and are repeated many times. For Example if I put in first column Country than Zones than Customer I see 3 Customer of USA but for example Zones is always Alaska I see sub total of Alaska that is the same of USA and I see another sub total for each Customer that has no sense.
