put ranking in the item description dynamically on hierarchy tree

[ViniciusScur]

Hello everyone,

I would like to include the ranking in the item description dynamically, this makes it easier to view and position the item

PBIX file: https://drive.google.com/file/d/164uH16XeotqUm7FoxFo1SjQVunc9QvPa/view?usp=sharing

In the example of the PBIX file above, filtering the column "6-Material" by "MAT004", for the "1-Area" we would like to have:

(001) Expedição, (002) Almoxarifado, (003) Compras.

Without filters applied, we would have for the column "1-Area":

(001) Almoxarifado, (002-Compras), (003) Expedição.

This Ranking would be extended to each of the items in the visual (Area, Cause, Category, SubCategory, Position, Material).

Is this possible?

Regards.

[v-stephen-msft · Accepted solution]

Hi @ViniciusScur ,

You can put the ranking measure into the tooltips.

Then you can sort by ranking measure,

Best Regards,

Stephen Tao

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

[v-stephen-msft]

Hi @ViniciusScur ,

You can sort in ascending and descending order according to the options in the red box, and choose which field to sort by.

Best Regards,

Stephen Tao

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

[ViniciusScur]

Hi Stephen,

I appriciate your feedback, however I need to order by the ranking measure. And I didn't find a solution for this situation, as I try to show in the example, I thougth to put te raking in the description of the columns.

Is there any solution for this? order by the ranking measure.

Regards, VInicius