How to apply sorting in Heat Map based on x-axis?
In a Heat Map, the default sorting is applied based on both the x-axis and y-axis. However, there might be situations where you want to sort the data based on the x-axis alone. This article will guide you through the process of applying sorting to a Heat Map based on the x-axis alone.
Steps to Apply Sorting Based on X-Axis
1. Configure the data source order for the y-axis column: To display the sort order configured for the x-axis, you need to set the data source order for the y-axis column. This will ensure that the sorting is applied only to the x-axis, and that the y-axis remains in its original order.
2. Apply sorting to the x-axis: After configuring the data source order for the y-axis column, you can apply the desired sorting to the x-axis. This can be done by selecting the appropriate sorting option from the available options, such as ascending, descending, or custom sorting.
3. Verify the sorting: Once the sorting has been applied, you can verify the results by checking the Heat Map. The data should now be sorted based on the x-axis alone, with the y-axis remaining in its original order.
By following these steps, you can easily apply sorting to a Heat Map based on the x-axis alone, allowing you to display the data in the desired order.
Related Articles
