Great Job. I like paretos charts. I do have 2 questions. Can we add a vertical line where 80% meet? and using a single slicer where we have the ability to switch Category and Product and the chart will change it? Thank You!
Hi, what if there are 2 (or more) countries with exactly the same sales value? Pareto line will have the same value for both countries (the line will be flat between these points)?
Thank you so much for this!! But I need help with one thing, my Pareto is working well with when I consider one field example like country field in this video, but I want to drill down to next level and it should work fine, eg city, town etc, I tried but it’s not working. How do I work? Please help.
I used this formula and it works but when I add a slicer to filter by Year it doesnt seem to work correctly, How can I create a pareto that when I select the year I would work correctly?
Great video. I really like that u have a nice understanding of technical and business-topics. Adding a second axis which cumulates the vales is a nice and fresh addition to boring column-charts. Well done. Keep up the "business-topics"
I tried to show the count of 80% in a card visual. It worked, but when I clicked on any column in pareto chart, the card value changes to 0 or blank. I used this measure for card visual: Contributed to 80% Revenue = SUMX(KEEPFILTERS(ADDCOLUMNS(ALLSELECTED(LC[Account Alias]),"Count",[Revenue Pareto])),IF([Count]
Lol did he seriously ask anyone to give him a thumbs down? I DARE anyone to try haha show us a more straightforward approach. Thanks man you're a champ! subbed
Hi, I wasn't able to understand one thing in var _cumulative sum= sumx(filter(_sumtable,[total sales] >_current) But in _sumtable we didn't have [total sales] we have [sales] ?
Another excellent video friend; the content of it is very precise; I have a question ; Have you done this analysis in a dynamic way, that is, can it be segmented in specific periods of time? Because most of the real cases that I have had, this analysis is required to be more dynamic; Regards
Hi Fernan, great video as always!! Question: How can i add to this measure a parameter slicer so the user can select how many itens he wants to keep in the graphic?
straight to the point, no ads. this guy is a life saver
Great Job. I like paretos charts. I do have 2 questions. Can we add a vertical line where 80% meet? and using a single slicer where we have the ability to switch Category and Product and the chart will change it? Thank You!
Hi, what if there are 2 (or more) countries with exactly the same sales value? Pareto line will have the same value for both countries (the line will be flat between these points)?
Same question! How would handle ties? Something with RANK…?
@@cathrerinezetadrones3169 Same! anyone solved it?
QUESTION: How to use a slicer to change from country to product in 1 pareto chart
Thank you so much for this!! But I need help with one thing, my Pareto is working well with when I consider one field example like country field in this video, but I want to drill down to next level and it should work fine, eg city, town etc, I tried but it’s not working. How do I work? Please help.
I used this formula and it works but when I add a slicer to filter by Year it doesnt seem to work correctly, How can I create a pareto that when I select the year I would work correctly?
This is a fantastic presentation. I love the way you broke it down and explained how this can be applied to any data set. Thank you.
Great video. I really like that u have a nice understanding of technical and business-topics.
Adding a second axis which cumulates the vales is a nice and fresh addition to boring column-charts. Well done. Keep up the "business-topics"
percentage part dosen't worked for me
Thank you!
I tried to show the count of 80% in a card visual. It worked, but when I clicked on any column in pareto chart, the card value changes to 0 or blank. I used this measure for card visual:
Contributed to 80% Revenue = SUMX(KEEPFILTERS(ADDCOLUMNS(ALLSELECTED(LC[Account Alias]),"Count",[Revenue Pareto])),IF([Count]
Lol did he seriously ask anyone to give him a thumbs down? I DARE anyone to try haha show us a more straightforward approach. Thanks man you're a champ! subbed
Hi,
I wasn't able to understand one thing in var _cumulative sum= sumx(filter(_sumtable,[total sales] >_current)
But in _sumtable we didn't have [total sales] we have [sales] ?
Very simple and easy to follow. Great teacher. Thanks for posting the lesson.
Another excellent video friend; the content of it is very precise; I have a question ; Have you done this analysis in a dynamic way, that is, can it be segmented in specific periods of time? Because most of the real cases that I have had, this analysis is required to be more dynamic; Regards
Hi Fernan, great video as always!!
Question:
How can i add to this measure a parameter slicer so the user can select how many itens he wants to keep in the graphic?
how did you move the visualization pane to the ribbon in PBI?
What I love the most is the simplicity of illustration to understand a hard topic ! Very well done 👏🏻👏🏻
Fantastic mate. Really useful. I am going to add this on live dashboard tomorrow. Thanks
You are Super awesome man.. This video helped me a lot. Thanx a tonnnn
Great presentation bro. I'm gonna use this for our channel managers to focus on the top customers. Good job.
Great content. Please where can u get free online data in which I can practice on?
Thanks
Can you please create some videos of what one can and cannot do in terms of fax in live connection?
Thank you! i found another gold youtuber. Keep it up sir!
Excellent one, thank you for sharing
Excellent 🎉... Thank for this
fantastic job, thank you so much!
useful chart thank you sir
Im your fan! Thanks Fernan
Hi Ferran, can you please make a series of DAX videos wherein we can learn how to make such complicated calculations ?
specifally DAX is not a difficult programming languange to understand and you dont have to understand all at once from the beginning
Doesnt work for meee1 :Ccc
awesome man
AWESOME!!
Great video !!
Thanks man, u explained it well. Need to present this today.