Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |