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,
I am creating a pareto chart with the below logic, but when i slice down with year it is giving me wrong percentage. (showing overall percentage is 22%)
can anyone help me. Also, attached the image PBIX file for your reference. ( Download wetransfer link: https://we.tl/t-vbYAWDqqLK )
Logic:-
Solved! Go to Solution.
This approach using RANKX and TOPN instead seems to be more straightforward.
https://www.dutchdatadude.com/power-bi-pro-tip-pareto-analysis-with-dax/
This approach using RANKX and TOPN instead seems to be more straightforward.
https://www.dutchdatadude.com/power-bi-pro-tip-pareto-analysis-with-dax/
@Akhil_1411 couple of things, you have to change ALL to ALLSELECTED in TOTASALES var
2nd, you have a filter on bar chat for the year 2016, not sure why but I guess you were testing something. Remove this filter. Try these and let me know how it goes?
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi @parry2k ,
I Changed to All to Allselected. But, when i apply a top N filter like top 10 subcategories it is filtering to 100 %. It should show the corresponding percentage of top 10 category values.
Note: i want this filter as a end user can select the year and see the results.
File: - https://we.tl/t-QYgrZbaYbe
Thanks,
Akhil.
@Akhil_1411 yes, it should work, once you update the measure and then you can use the year as a slicer, it already worked for me and I test it on your file at my end.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Akhil_1411 here it is after the measure change, works perfectly fine
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi @parry2k ,
I Changed to All to Allselected. But, when i apply a top N filter like top 10 subcategories it is filtering to 100 %. It should show the corresponding percentage of top 10 category values.
Note: i want this filter as a end user can select the year and see the results.
File: - https://we.tl/t-QYgrZbaYbe
Hi @Akhil_1411
I opened a new page and Re created your visual. it is working fine using Year slicer. Some buging your visual.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @aj1973 ,
Pareto Rule : 80 -20 percentage. It should show 100%. If you see in your re-created chart the overall cumulative percentage is showing upto 26.05%. This is wrong
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |