Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello Guys,
I need some help with the pareto chart. The chart itself works perfecly, however I need to group the org_name (X axis) as it extends for too long. I am not able to do this in Edit Query as I created the chart using DAX.
I also used the colors to show top 20% etc..
You can see below that the chart extend for quite a bit.
This is an example of what I'm trying to replicate:
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Would need some sample data and your calculations, no idea what you are doing here exactly. Seems like you would potentially want to create some kind of calculated table with representative rows but can't say for sure.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |