Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have created a Pareto chart (80/20) in Power BI which works but I'd like the chart to look more "cleaner" and look similar to one i created in Tableau.
I have over 5000 suppliers so the graph doesn't look so great in Power BI the way it is currently designed. Is there a way to make the Power BI chart look similar to the one created in Power BI with percentages on the x and y axis and the supplier names in the tooltip of the actual curve/line. See images below for the Power BI version and Tableau version.
Power BI Pareto Chart
Tableau Pareto Chart
Solved! Go to Solution.
Hi @Anonymous ,
You have 5000 suppliers on the x-axis, so the Pareto chart does not look like the two-eight principle. I suggest you reduce the number of suppliers on the x-axis to make the visual look more compact. You can use group function in Power BI to group suppliers and you can use group as x-axis instead of 5000 suppliers. For more details, please refer to https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @Anonymous ,
You have 5000 suppliers on the x-axis, so the Pareto chart does not look like the two-eight principle. I suggest you reduce the number of suppliers on the x-axis to make the visual look more compact. You can use group function in Power BI to group suppliers and you can use group as x-axis instead of 5000 suppliers. For more details, please refer to https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
@Anonymous , I did a quick check. I did not see any visual equivalent of the second visual.
Please refer, if you can find one : https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |