Forum Discussion
Field Parameters_ Sorting the visual based on measure and in ascending order issue in bar chart
When you create field parameter it creates a table with hidden columns
You can view these in the view hidden menu
X measure parameters = { ("Quantity", NAMEOF('Dax'[Quantity]), 0), ("Value", NAMEOF('Dax'[Value]), 1), ("Freight", NAMEOF('Dax'[Freight]), 2) }The "order" column controls what sequence the field parameters appear in the slicers and headers.
We can capture and use this field to contol the sort sequence of your clustered bar chart.
Create measure.
Sorter = VAR Xoption = SELECTEDVALUE('X measure parameters'[X measure parameters Order]) RETURN SWITCH(Xoption, 0,[Quantity], 1,[Value], 2, [Freight] )The SELECTEDVALUE gets the selected "order" for the measure you picked on the slicer.
The SWITCH then gets the equivalent measure value
Add the Sorter to your your clustered bar chart as tootltip.
The click on three dots [...], Sort axis, Sorter, Descending
Change the measure to handle multiple selections if required, so it slected you prefered measure sort sequence.
Please click [accept solution] and thumbs up buttons to show your appreciation.
Super UserHi Anonymous ,
To address the issue of sorting a clustered bar chart in Power BI when using field parameters for both the x-axis and y-axis, you can create a dynamic sorting measure using DAX. This issue arises because field parameters change the underlying data in the visual, which can cause the sort order to reset when parameters are switched. The solution involves creating a DAX measure that dynamically determines the value to be used for sorting, based on the selected parameter. For example, you can use a SWITCH function in the measure to return the relevant measure's value depending on the active selection from the field parameter. Once the measure is created, it can be added to the visual without being displayed, and you can configure the chart to sort by this measure in ascending or descending order as needed. This ensures that the sort order adapts dynamically to changes in the selected field parameter. To further enhance the user experience, you can also provide an option for users to explicitly select a sorting preference through a slicer. By anchoring the sort logic to a consistent calculated measure, this approach resolves the issue and ensures the visual maintains the desired sort order regardless of parameter changes.
Best regards,
Can you give an example. I have created a field parameter with units and units YOY na dcreated a clustered col chart for this for each commodity(x axis is fixed). The parameter selection is resetting the sort order. Is there a way I can fix the sort order to Units YOY sort descending using a measure. I am new to PBI so still in learning phase.