Forum Discussion
How to Create Index number on the visual
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
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.
2 Replies
- amitchandak
Super User
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
v-jingzhangCommunity Support
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.
