Forum Discussion
Adding to X Axis
I had someone provide me a great way to show Top 3 Locations and their Top 3 Injury Cause by first count and then using sum to break ties. It works great if X axis only has Reporting Location on Top...
Hi bdehning,
Thank you for reaching out to the Microsoft Fabric Forum Community.
To make your chart sort correctly when showing Reporting Location Address on the X-axis: Create a unique identifier by combining Location City, Address, and Cause Grouping (e.g., City | Address | Cause).
Modify your sort measure to incorporate this combination so it can rank each unique Location-Address-Cause properly. Use this updated sort measure to sort your visual ensuring the visual uses either a hierarchy or a concatenated column (like City - Address) on the X-axis.
If you find this response helpful, please consider marking it as the accepted solution and giving it a thumbs-up to support others in the community.
Thank you & Regards,
Prasanna Kumar