Get top 5 bars in stacked bar chart visual

[Sanandh C k]

Hi ,

Could you please help me on to get the tops 5 bars in a stacked barchart in attached dxp

[Gaia Paolini]

If you rank by number of students, the top 5 bars would be all the bars, as there are only three ranks of teachers: those who have 7 students, those who have 5 and those who have 4.

You already have the [studentCount] column. So you could use it by defining a new ranking column

RankNew:DenseRank([studentCount],'desc')

Then limit your bar by expression:[RankNew]

[Sanandh C k]

Hi Gaia,

As I created the Studentcount column as calculated column , Is there any way to change the values when we apply the filters.Thanks,

Sanandh

[Gaia Paolini]

sorry that was not part of the original question. A calculated column does not react to filters.