Sort Axis in one clustered bar chart should dynamically sort axis in other two clustered bar charts.

[Optimusprime_25]

Hello Team,

Requirement:

We have three clustered bar charts and in Y axis we have same column (Dimension) in all 3 charts. Whenever user selects sort Axis in one clustered bar chart, it should dynamically sort Y-axis (Dimensions) in other two clustered bar charts in Power BI report.

From above image, whenever user sort axis by Type in first chart (Blue colored bars), then it should sort and also it should sort axis by Type dynamically in other two charts as well.(Green and Red colored bars)

Thanks in advance.

[Anonymous]

Hi @Optimusprime_25 ,

Unfortunately, this feature is not supported in the current version.

If you would like to suggest  feature improvements, you may  vote the idea and comment here  to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Or you can use the following method instead.
(1) Create a new table, click "transform data" to enter the power query editor, sort the [type] columns in ascending order, then add index columns, click "close and apply".

(2) Create the model relationship as shown in the figure below.

(3) Select the [type] column and sort by index column.

(4)Use the [type] column of the new table as the y-axis to create three visuals.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.