Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Can anyone please help in trying to find a way to show, based on Quarter 1 and Quarter 2, rows as a percent of total. in POWER BI
Current view in Power BI showin percent of row total.... I need percent of row total but based on parent column... like for Q1 it should be 20% for adjusted and 80% for FTC to malke 100% not like below where its 20% then 40% then 40% to make 100%.
IN EXCEL IT IS POSSIBLE by JUST using "VALUE FIELD SETTINGS" THEN SHOWING VALUES AS " % OF PARENT COLUMN TOTAL" but I cant do this in power bi?? Need this above view in power BI! Anyone can help please?
THANKS!
Solved! Go to Solution.
Hi @jagbatth ,
Please try:
Measure =
var _a = SUM('Table'[Errors])
var _b = CALCULATE(SUM('Table'[Errors]),REMOVEFILTERS('Table'[Type]))
return DIVIDE(_a,_b)
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your reply,
So in Excel there is an option of value field settings, summarize value by and then show value as>> % of parent column total. In my case I have 2 quarters (PARENT COLUMN) Q1 2023 and Q2 2023 and within that I have two other sub categories ADJ and FTC and as you can see from screen shot above, in excel we can show the percentage by row based on parent column (82 + 18 for CA = 100%.) However when trying to do same thing in Power BI, we can not achive this as the only options are: Show values as % of Grand total, as % of column total and the one I have chosed: % or row total. BUT I do not need this! I need Percentage of row total at the Quarter level!
I have triend so many formulas and cannot get this to work.
My raw data is below:
Please help!
Thank you.
Hi @jagbatth ,
Please try:
Measure =
var _a = SUM('Table'[Errors])
var _b = CALCULATE(SUM('Table'[Errors]),REMOVEFILTERS('Table'[Type]))
return DIVIDE(_a,_b)
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Fantastic! Thank you so much Jianboli! Your the best!
Hi @jagbatth ,
What does your original data look like?
Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?
Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
51 | |
35 | |
20 | |
15 | |
14 |
User | Count |
---|---|
94 | |
80 | |
37 | |
22 | |
18 |