How to Create Index number on the visual

[Anonymous]

i need to create index number dynaically on the table visal.

eg: I'm having a price column , the price ciolumn should be in ascending order based on this in need index number 1,2,3,4.... dynamically till last row

note : The price column is calculate column

[v-jingzhang · Accepted solution]

Hi @Anonymous 

You can create a measure to rank the prices dynamically. Here are two blogs for your reference:

Showing Ranking in a Visual in Power BI using RANKX DAX function - RADACAD

Use of RANKX in Power BI measures - SQLBI

If you can provide some sample data & output and which section will be dynamic, we can try to provide DAX codes for the measure. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[amitchandak]

@Anonymous , Then max you can have at visual level is Rank(means you need measure). Use rank tie-breaker if needed

Rank Tie breaker
https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-Columns/ba-p/918655
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/

for column, index column in power query can be used