Power BI User on 31 Aug 2015 20:28:03
Most of the time working with Power BI I have spend to build right formulas for Pareto Chart, that shows running total and custom values. Excel 2016 solved the problem, but not for Power BI yet.
Also, great feature will be to add customization of Waterfall chart - sort by, set value as Subtotal or Total
- Comments (4)
RE: Pareto Chart and Excel 2016 charts
I have also tried to make Pareto charts in power BI. I have found this tutorial on how to make a Pareto chart very helpful.
http://powerbi.tips/2016/10/pareto-charting/
RE: Pareto Chart and Excel 2016 charts
The blog posts for this are OK but a bit clumsy as you cannot easily change columns and if you have multiple dimensions it can get weird when interacting with other visuals. This needs to be addressed and be made as easy as it is in Excel. I think the shortest method would be enabling a second axis as a parameter.
RE: Pareto Chart and Excel 2016 charts
must be able to count how many dates from rows fall into a certain month cumulatively for charting schedule actuals with dates over time...
RE: Pareto Chart and Excel 2016 charts
Hi Anonymous, my blog post on Pareto charts with DAX may help: http://dutchdatadude.com/power-bi-pro-tip-pareto-analysis-with-dax/#comment-1101