Forum Discussion
Share calculation based on column output
Hi Team,
I am trying to get the share value, can you please help me.
Below is my sales.
My requirment is
for Black Tea = 7354.8/25459.4.
Please help me.
Anonymous
For Sales, just select the option Show value as Percent of column total. See it all at work in the attached file.
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
10 Replies
Anonymous
For Sales, just select the option Show value as Percent of column total. See it all at work in the attached file.
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Hi Anonymous
Check this out
https://community.powerbi.com/t5/Desktop/How-To-Display-Percentage-of-Total/m-p/892172
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Share the pbix, with dummy data if necessary
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Here is the pbi file
https://drive.google.com/file/d/1nnp8ajrCfy4yDvrTlS69beGkje0TZM9g/view?usp=share_link.
Thanks in advance !
Anonymous
That link seems to require logging into Google. Can you remove that requirement (or share it elsewhere)?
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Anonymous
URL to the file hosted elsewhere is fine. It just needs to be accessible without the need to log in
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Here is my sample data,
Using Metrix visual and showing Maker in Row & Category in Column and Sales in Value.
Maker_SCI Category Sales CC BT 73538 CC Co 900379.1 CC CK 171813.9 CC Eg 82051.6 CC Fl 41298.3 CC Ju 49788.7 CC Ns 269539.4 CC Others 14200.4 CC Sp 61121.8 CC Wa 121166.8 AA BT 54817 AA Co 397434.1 AA CK 25115.5 AA Eg 45378.7 AA Fl 26116.9 AA Ju 26425.7 AA Ns 127688.5 AA Others 11366.7 AA Sp 12259.2 AA Wa 60933.8 BB BT 82386.6 BB Co 117761.8 BB CK 2620 BB Fl 17696.1 BB Ju 19429.9 BB Ns 50038.8 BB Others 19802.6 BB Sp 29955.8 BB Wa 15011.9 AB BT 7998.2 AB Co 220669.2 AB CK 924.6 AB Eg 24507 AB Fl 36718.2 AB Ju 21253.8 AB Ns 35122.3 AB Others 37988 AB Sp 1955.7 AB Wa 39972.4 IT BT 1627.9 IT Co 83520.2 IT Eg 6251.2 IT Fl 1564.8 IT Ju 12291.5 IT Ns 146866.3 IT Others 4241.2 IT Wa 8023.7 DY BT 7705.6 DY Co 230389.9 DY CK 74.9 DY Eg 3623.8 DY Fl 8236.4 DY Ju 22251.7 DY Ns 23311.9 DY Others 14360 DY Sp 2306.8 DY Wa 16048.1 PA BT 11986.1 PA Co 38937.5 PA CK 996.5 PA Eg 6217 PA Fl 3706.8 PA Ju 21426.7 PA Ns 16114.6 PA Others 3090.8 PA Sp 11497.7 PA Wa 7178.3 Others BT 14455.4 Others Co 98853.5 Others CK 769.4 Others Eg 103582.2 Others Fl 32725.1 Others Ju 27921.3 Others Ns 33557.2 Others Others 28101.7 Others Sp 68942.7 Others Wa 22677.2