cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JamesCH Frequent Visitor
Frequent Visitor

Report Sub Totals within a report

Have been given a data set and a layout from an excel spreadsheet which is wanted to be shown in Power BI.

 

Example.jpg

 

 

 

Not quite sure the best way of doing this as a Power BI Novice. Not even sure of this is the right use pf Power BI.

 

Any help and advice on this would be welcome

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Report Sub Totals within a report

@JamesCH If you are asking if the layout is possible, then yes. Here is a quick example of using a Matrix to show a example of your report. You may need to build some measures for certain calculations, but if your goal is to produce the same look, you should be able to. Note in this sample, I've used just a custom style, all the colors and lines are formatable to achieve the color scheme you are looking for.

example.JPG

Near SE WI? Join our PUG Milwaukee Brew City PUG
5 REPLIES 5
BhaveshPatel Super Contributor
Super Contributor

Re: Report Sub Totals within a report

Hi There, 

 

Please post your sample data file to suggest a solution. 

 

 

Thanks & Regards,

Bhavesh

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
JamesCH Frequent Visitor
Frequent Visitor

Re: Report Sub Totals within a report

TonnesProductYearMonthRegionGross ValueDelivered PriceStandardVariableType
3.62PROD A2016AprilRegion A1,840.631,840.631,629.72998.07TYPE A
6.03PROD A2016MayRegion A3,085.713,085.712,716.511,663.63TYPE A
7.81PROD A2016JuneRegion A4,028.894,028.893,567.782,153.56TYPE A
3.96PROD A2016JulyRegion B2,010.962,010.961,773.061,090.43TYPE B
7.64PROD B2016AugustRegion B3,886.613,886.613,425.972,106.97TYPE B
4.02PROD B2016SeptemberRegion C2,072.472,072.471,800.851,107.52TYPE B
0PROD B2016AprilRegion D6,706.766,706.760.000.00TYPE A
23.89PROD C2016MayRegion A12,767.9312,767.9310,753.486,585.59TYPE A
21.82PROD C2016JuneRegion B11,661.9711,661.979,822.016,015.14TYPE A
23.83PROD A2016JulyRegion A12,739.6012,739.6010,886.066,570.97TYPE B
7.87PROD A2016AugustRegion A4,277.564,277.563,124.762,170.38TYPE B
3.92PROD A2016SeptemberRegion A2,078.862,078.861,756.471,080.23TYPE B
3.97PROD A2016AprilRegion B2,126.732,126.731,781.581,095.67TYPE A
11.93PROD B2016MayRegion B6,383.956,383.955,347.873,288.93TYPE A
1.56PROD B2016JuneRegion C1,124.641,124.64713.47430.66TYPE A
2.01PROD B2016JulyRegion D1,101.571,101.57891.95543.06TYPE B
18.04PROD C2016AugustRegion A10,102.6510,102.658,016.024,880.47TYPE B
22.08PROD C2016SeptemberRegion B12,117.8512,117.859,625.245,973.89TYPE B
20.2PROD A2016AprilRegion A11,311.3611,311.368,804.315,464.38TYPE A
2.03PROD A2016MayRegion A1,135.341,135.34883.70548.47TYPE A
2.02PROD A2016JuneRegion A1,105.961,105.96882.28545.22TYPE A
9.95PROD A2016JulyRegion B5,704.305,621.384,423.772,693.36TYPE B
1.94PROD B2016AugustRegion B1,112.321,096.15862.62525.20TYPE B
11.85PROD B2016SeptemberRegion C6,636.446,537.755,265.503,205.84TYPE B
3.91PROD B2016AprilRegion D2,188.432,155.881,736.351,057.16TYPE A
5.79PROD C2016MayRegion A3,244.843,196.582,574.531,567.48TYPE A
13.92PROD C2016JuneRegion B7,794.237,678.326,184.123,765.13TYPE A
2PROD A2016JulyRegion A1,120.261,103.60888.84541.16TYPE B
24.01PROD A2016AugustRegion A13,443.7513,243.7910,668.336,495.30TYPE B
2PROD A2016SeptemberRegion A1,117.751,101.12887.06540.08TYPE B
2.04PROD A2016AprilRegion B1,144.641,144.64908.40553.07TYPE A
21.81PROD B2016AprilRegion B12,213.0412,213.049,692.385,901.10TYPE A
12.19PROD B2016AprilRegion C6,912.296,790.385,314.853,298.65TYPE A
7.86PROD B2016AprilRegion D4,456.054,377.463,426.252,126.50TYPE B
23.37PROD C2016MayRegion A12,201.3912,201.3910,223.996,330.26TYPE B
23.5PROD C2016JuneRegion B11,964.1511,964.1510,280.426,365.20TYPE B
24.29PROD A2016JulyRegion A12,033.6012,033.6010,623.816,577.81TYPE A
22.84PROD A2016AugustRegion A11,319.9011,319.9010,184.406,186.17TYPE A
14.11PROD A2016SeptemberRegion A6,994.156,994.156,199.943,822.21TYPE A
4.04PROD A2016AprilRegion B1,999.821,999.821,772.731,092.87TYPE B
10.13PROD B2016AprilRegion B5,123.865,123.864,450.492,743.69TYPE B
24.03PROD B2016MayRegion C12,155.1312,155.1310,512.266,508.75TYPE B
4.03PROD B2016JuneRegion D2,152.852,152.851,794.761,090.16TYPE A
22.5PROD C2016JulyRegion A12,132.1012,132.1010,031.906,093.54TYPE A
22.96PROD C2016AugustRegion B12,380.2012,380.2010,087.206,218.67TYPE A
24.45PROD A2016SeptemberRegion A13,186.3413,186.3410,903.646,623.05TYPE B
10.21PROD A2016AprilRegion A5,504.695,504.694,551.772,764.82TYPE B
14.27PROD A2016MayRegion A7,692.987,692.986,361.243,863.92TYPE B
8.02PROD A2016JuneRegion B4,291.804,291.803,525.252,173.28TYPE A
11.99PROD B2016JulyRegion B6,466.186,466.185,245.413,247.74TYPE A
4.01PROD B2016AugustRegion C2,162.762,162.761,788.511,086.37TYPE A
8.04PROD B2016SeptemberRegion D4,333.614,333.613,583.712,176.81TYPE B
23.96PROD C2016AprilRegion A12,919.9512,919.9510,481.646,489.79TYPE B
2.02PROD C2016AprilRegion B1,080.441,080.44900.72547.11TYPE B
2.04PROD A2016MayRegion A1,089.531,089.53908.30551.72TYPE A
7.37PROD A2016JuneRegion A3,941.993,941.993,223.981,996.15TYPE A
24.44PROD A2016JulyRegion A11,711.9811,711.9810,897.406,619.25TYPE A
12.04PROD A2016AugustRegion B6,744.566,644.235,370.443,262.09TYPE B
4.02PROD B2016SeptemberRegion B2,249.492,216.031,791.191,088.00TYPE B
4.05PROD B2016AprilRegion C2,301.882,268.121,780.641,097.75TYPE B
1.97PROD B2016MayRegion D1,134.871,118.46865.50533.57TYPE A
1.8PROD C2016JuneRegion A1,006.00991.04789.05486.44TYPE A
5.76PROD C2016JulyRegion B3,224.683,176.722,529.271,559.27TYPE A
3.56PROD A2016AugustRegion A2,025.621,995.941,565.36965.03TYPE B
22.19PROD A2016SeptemberRegion A11,676.5511,676.559,749.356,010.39TYPE B
24.34PROD A2016AprilRegion A12,804.6912,804.6910,691.296,591.09TYPE B
23.5PROD A2016MayRegion B12,366.3712,366.3710,325.326,365.47TYPE A
1.98PROD B2016JuneRegion B1,035.191,035.19870.33536.55TYPE A
22.77PROD B2016JulyRegion C11,709.3411,709.349,960.216,166.94TYPE A
2.04PROD B2016AugustRegion D1,047.051,030.09907.86551.45TYPE B
1.93PROD C2016SeptemberRegion A989.99973.95858.81521.65TYPE B
1.79PROD C2016AprilRegion B888.35888.35780.84483.46TYPE B
15.68PROD A2016AprilRegion A7,802.647,802.646,860.034,247.44TYPE A
22.94PROD A2016AprilRegion A11,750.0411,750.0410,035.456,213.52TYPE A
24.1PROD A2016MayRegion A12,077.6711,908.9610,746.686,527.71TYPE A
9.94PROD A2016JuneRegion B4,979.704,910.144,430.932,691.42TYPE B
1.89PROD B2016JulyRegion B949.14935.88844.54512.99TYPE B
17.82PROD B2016AugustRegion C8,930.598,805.847,795.734,826.78TYPE B
1.97PROD B2016SeptemberRegion D986.22972.44860.89533.03TYPE A
2.06PROD C2016AprilRegion A1,019.441,005.00902.45558.76TYPE A
2.01PROD C2016AprilRegion B991.76977.71877.95543.59TYPE A
17.11PROD A2016AprilRegion A8,447.008,327.247,628.494,633.67TYPE B
4.04PROD A2016MayRegion A1,991.631,963.321,803.231,095.31TYPE B
4.04PROD A2016JuneRegion A1,995.881,967.611,801.001,093.96TYPE B
4.05PROD A2016JulyRegion B2,002.801,974.431,807.241,097.75TYPE A
2PROD B2016AugustRegion B989.87975.84893.59542.78TYPE A
1.98PROD B2016SeptemberRegion C994.24980.35871.65537.36TYPE A
12.07PROD B2016AprilRegion D6,047.115,962.645,301.493,268.32TYPE B
1.76PROD C2016AprilRegion A870.76858.42771.22477.51TYPE B
1.96PROD C2016MayRegion B983.71969.97858.71531.67TYPE B
11.94PROD A2016JuneRegion A5,881.805,798.205,224.423,234.74TYPE A
17.05PROD A2016JulyRegion A8,546.448,427.077,459.774,618.77TYPE A
12.18PROD A2016AugustRegion A5,997.055,911.815,429.753,298.12TYPE A
16.17PROD A2016SeptemberRegion B7,990.457,877.267,210.244,379.61TYPE B
Super User
Super User

Re: Report Sub Totals within a report

@JamesCH If you are asking if the layout is possible, then yes. Here is a quick example of using a Matrix to show a example of your report. You may need to build some measures for certain calculations, but if your goal is to produce the same look, you should be able to. Note in this sample, I've used just a custom style, all the colors and lines are formatable to achieve the color scheme you are looking for.

example.JPG

Near SE WI? Join our PUG Milwaukee Brew City PUG
JamesCH Frequent Visitor
Frequent Visitor

Re: Report Sub Totals within a report

fantastic.

 

So I need to look at creating a matrix then but impressed that you were able to get the look and feel so accurate to what I wanted

Super User
Super User

Re: Report Sub Totals within a report

@JamesCH Wish I could take credit for my outstanding prowess, but the output is just default behaviour for the most part from Power BI. The only manual part is finding and setting the appropriate colors Smiley Happy

Near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 390 members 4,258 guests
Please welcome our newest community members: