Custom sort in bar chart In Power BI

Question

I am developing a new report using Power BI, By default, the bar chart is sorted by the max value also I can sort the bar chart ascending and descending but I need to perform power bi custom sort bar chart in custom order

In this example, I want to change the sort of stacked bar chart to be (Low, Medium, High) instead of sorting ascending or descending per axis name or value. (High, Low, Medium).

How can I change the order of Axis of stacked bar chart in Power BI and How to create custom sorting in Power BI Bar chart?

Comments

Which order you need

---

Create a lookup table and try to link it with relation!

Answer 1

Power BI Custom sorting order Bar Chart

• At "Home", Click on Enter Data to create a Temp table for your status table.
  
• Add two columns, one for ID and one for the same corresponding value of your status column.
  
• In the Model section, Make sure that the main table has a relation with your new status table with the status column as shown below:
  
• In the Data section, sort the status column with the ID column.
  
• Now, add the status column of the new table in Axis, and drag the count in the values.
  
  Output

Show items with no data as a Zero in Power BI

The above solution would work properly if all Axis has values. but if there are no rows with a High value (count of rows is ZERO), so the bar for a high value will not be shown in the bar chart as shown below:

So, to avoid this issue and show a bar chart with zero Axis value, you should do the following:

• Create a measure to calculate the count.
  
• Set the Axis and the value as shown below
  

Output

---

Download

• Download the PIBX file at Power BI Custom Sort Order Stacked Bar Chart
• Follow Power BI Repo to get more PIBX files samples with complex DAX formulas.