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

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

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

 

Capture.JPG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

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

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

D



Have I answered your question?
Please mark my post as the solution.


Please don't forget your Kudos if you don't mind. Thanks.


View solution in original post

3 REPLIES 3
Highlighted
Super User IV
Super User IV

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

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


Have I answered your question?
Please mark my post as the solution.


Please don't forget your Kudos if you don't mind. Thanks.


Highlighted
Regular Visitor

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

Hi Darlove,

Thanks for responding.

Here's the data I'm working with:

 

YearProfit Livestock TradingContract IncomeDiesel Fuel RebateGrain IncomeWoolContractsDepreciationFeriliser & SpreadingFuel & LubricantsGrain Selling CostsInsuranceInterestRentRepairs & MaintenanceSeed Grading & PicklingSprays & PoisonsWages
30/06/201028084252778121523252645403326620405242333576814444741400001349851828472224
30/06/201145160322310596229027275596027557853750034470993213370526914000020476484249883839
30/06/20126659861001083048535838689380557347375223451010038126844997440000176301940407133869
30/06/201340418094363653873588806014737332249078794128943653340000279370399064627
30/06/201427163068632535193951703922342510203899626136073262440000154690480554232
30/06/2015559700859434879938791040050409802430410547129233965640000161960530765264
30/06/201684464082625153784564603922344200270411558013973383104000018483599565094940
30/06/2017679020890237598364569039228386702274914325134493616940000192740564226967
30/06/2018767310100873421306612214702435635507233229905307643512660000227080562235881
30/06/201985743055061864786274701497934500240383208116843438060000221870542083133

 

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,

Highlighted
Super User IV
Super User IV

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

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

D



Have I answered your question?
Please mark my post as the solution.


Please don't forget your Kudos if you don't mind. Thanks.


View solution in original post

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors