Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
8k views
in Power BI by 10 15 24

In Power BI, I am working on an Arabic dashboard and I want to know how to show a Power BI bar chart from Left to Right like the below image

Power BI Right to Left Bar chart Direction

So, Is it possible to change Power BI bar chart orientation from left to right, any workarounds, please?


2 Answers

1 like 0 dislike
by 86 158 331
selected by
 
Best answer

Power BI Bar Chart from Left to Right

Unfortunately, there is no option in the Bar chart visual to show the bar from left to right in Power BI.however, you can go through the following workarounds:

1 ) Show bar chart from left to right using Tabel conditional formatting

You can use this workaround to show the Power BI bar chart from Left to Right as shown below:

Show bar chart from left to right using Tabel conditional formatting

Steps

  • Create a table.
  • Add the value that would like to show as a bar chart (Y-Axis) to be the first field in your table.
  • Add the x-axis field value as the second field in your table
  • Remove the table header as mentioned at Remove the table column header in Power BI.
  • Set the style to None.
  • Turn off the vertical grid in the grid section.
  • Turn off Totals in the Total section.
  • In the Field formatting, align the Y-Axis field to the Left.
  • Turn off Title, Visual header, Border.
  • Turn on the Tooltip.
  • In the conditional formatting, enable Data Bar, and click on the Advanced Settings to set the bar direction from Right to Left as shown below:

Use bar chart conditional formatting in a table in Power BI

One of the main cons of this workaround is you can't change the bar color for each value.


2 ) Show bar chart from left to right using Y-Axis concatenation

You can also use this workaround to show the Power BI bar chart from Left to Right as shown below:

Show bar chart from left to right using Y-Axis concatenation

Steps

  • First, you should create a measure to multiply the Y-Axis to -1 as shown below

      LTRBarMeasure = sum(Sites[Viewers]) * -1
    
  • Again, create a new calculated column to concatenate the X-Axis with Y-Axis

      Sites with value = FIRSTNONBLANK(Sites[Site],true()) & " ( " & FIRSTNONBLANK(Sites[Viewers],true()) & " )"
    
  • Add the measure in values.
  • Add the column in Axis.
  • Turn off the data label.
  • Turn off tooltip.

One of the main cons of this workaround is you should disable data label and tooltip to avoid showing the value in Minus.


3 ) Show bar chart from left to right using Cards

Besides the above workarounds, you can also use this workaround to show the Power BI bar chart from Left to Right as shown below:

Show bar chart from left to right using Cards

Steps

  • First, you should create a measure to multiply the Y-Axis to -1 as shown below

       LTRBarMeasure = sum(Sites[Viewers]) * -1
    
  • Add the measure in values.
  • Add the column in Axis.
  • Turn off the data label.
  • Turn off tooltip.
  • Sort your chart Axis to make it static.
  • Create a card for each Axis value filter by each Axis value.

create a card filter in Power BI

This solution is only suitable if you have static Axis values, and you may find some difficulties to adjust the card position for each bar. Moreover, you should turn off the data label and tooltip


4 ) Show bar chart from left to right using Multi Axes Chart

You can also use a paid Multi Axes Chart to show the Power BI bar chart from Left to Right as shown below:

Show bar chart from left to right using Multi Axes Chart

Steps

  • Download Multi Axes Chart
  • Import the download chart in your visuals.
  • Set the X-Axis and Y-Axis.
  • In the Y-Axis, turn on the Reverse Axis.

Download

1 like 0 dislike
by 16 25 39
edited by

To change the bar chart position from left to right In Power BI Desktop, You can change the position of the y-axis from left to right in the bar chart as below:

change bar chart position from left to right

The result

bar chart from left to right in power BI

by 10 15 24
1 0
I want to change the direction of the bars itself, not labels only.
If you don’t ask, the answer is always NO!
...