Only displaying "tallest" bars in bar chart

Question

I am trying to create a clustered bar chart in PowerBI Desktop, where only the N "tallest" bars are displayed.

My dataset consists of a small number of rows but a large number of columns.

I have tried the following:

• Transform the table in absolute values (since I am interested in bar height, not negative/postive strictly)
• Try to apply the "top N" filter on the axis datafield

However, nothing happens. The chart currently looks like this (without applying the transformation of the absolute value): Clustered bar chart

I basically want the same chart, but only display the N tallest bars.

Answer 1

You might have to pivot your table, so you have a "column name" field and a "value" field.

Then you need to use the TOP N on the Legend field, like this:

Filters:

Result: