topic Re: Line & Stacked Column - Show column segments as percentage of line in DAX Commands and Tips

Line & Stacked Column - Show column segments as percentage of line

chuckie2706 — Tue, 17 Mar 2020 10:52:16 GMT

Hi,

Perhaps super easy for some.

I have a line (Total Income for the year) and I have the stacked column representing expenses for that year.

I'd like to have the segments of the stacked column show the percentage of the total income in that year. That's the first issue.

Secondly, the example I'm using is a farmer, however I'll have other industries where different components will be represented in the column.

Will that require a new DAX command for every important column component in every clients Power BI file?

TIA,

Justin

Re: Line & Stacked Column - Show column segments as percentage of line

Anonymous — Sun, 22 Mar 2020 10:58:41 GMT

Hi there.

Would you please be able to give us some data to work with?

Secondly, I don't fully get these 2 lines:

Secondly, the example I'm using is a farmer, however I'll have other industries where different components will be represented in the column.

Will that require a new DAX command for every important column component in every clients Power BI file?

Would you please be able to expand upon this a bit?

Thanks.

Best
D

Re: Line & Stacked Column - Show column segments as percentage of line

chuckie2706 — Sun, 22 Mar 2020 22:36:53 GMT

Hi Darlove,

Thanks for responding.

Here's the data I'm working with:

Year	Profit Livestock Trading	Contract Income	Diesel Fuel Rebate	Grain Income	Wool	Contracts	Depreciation	Feriliser & Spreading	Fuel & Lubricants	Grain Selling Costs	Insurance	Interest	Rent	Repairs & Maintenance	Seed Grading & Pickling	Sprays & Poisons	Wages
30/06/2010	28084	2527	7812	152325	26454	0	33266	20405	24233	3576	8144	44741	40000	13498	518	2847	2224
30/06/2011	45160	3223	10596	229027	27559	6027	55785	37500	34470	9932	13370	52691	40000	20476	484	24988	3839
30/06/2012	66598	6100	10830	485358	38689	3805	57347	37522	34510	10038	12684	49974	40000	17630	1940	40713	3869
30/06/2013	40418	0	9436	365387	35888	0	60147	37332	24907	8794	12894	36533	40000	27937	0	39906	4627
30/06/2014	27163	0	6863	253519	39517	0	39223	42510	20389	9626	13607	32624	40000	15469	0	48055	4232
30/06/2015	55970	0	8594	348799	38791	0	40050	40980	24304	10547	12923	39656	40000	16196	0	53076	5264
30/06/2016	84464	0	8262	515378	45646	0	39223	44200	27041	15580	13973	38310	40000	18483	599	56509	4940
30/06/2017	67902	0	8902	375983	64569	0	39228	38670	22749	14325	13449	36169	40000	19274	0	56422	6967
30/06/2018	76731	0	10087	342130	66122	1470	24356	35507	23322	9905	30764	35126	60000	22708	0	56223	5881
30/06/2019	85743	0	5506	186478	62747	0	14979	34500	24038	3208	11684	34380	60000	22187	0	54208	3133

In relation to my other query, perhaps a better way to phrase it is, if I have 50 farmers to run through Power BI, can I create 1 measure and have it copy it across to all the other files or will I need to open each of the 50 files and create the measure in each. Specifically I'm envisioning a situation where down the line I come up with a new aspect I want to drill into. Will I need to open all 50 files and add that new measure, or can I get it to automatically add from that first file.

Hope that makes sense.

Thanks,

Re: Line & Stacked Column - Show column segments as percentage of line

Anonymous — Mon, 23 Mar 2020 00:45:56 GMT

I still don't quite get what you're trying to do... Certainly, if you have several files with the same structure, you should import them all in one go and consolidate them into dimensions and fact table(s). You just need measures in the pbix file. You certainly don't need copy any measures.

But here's your visual the way you wanted it:

https://1drv.ms/u/s!ApyQEauTSLtOgYNBfmb2Q45ozwO7ug?e=VB9OhN

Best