Dynamic row numbering in Table visual based on filtered value

[Anonymous]

Hi,

I wanted to have serial number to be created dynamically in the PowerBI dashard for the Table visual. There are 3 Filtered defined :

1. District

2. Block

3. Mobile users

The Report ->Table get the data from 2 diffirent Data ->Tables based on the values selected through in the above defined filters (Report-> Slicer).

It is working perfectally fine. However, we may also need to have a serial number for each of the displaying records:

Data Tables are linked through users_id :

Table#1 : pbi_dentified_locations : district, block and Subcenter

Table#2 : pbi_dentified_and_followup : All values being referred except the above 3 values.

I tried it by applying the below measures, where i got an index column created in Table#2.

CALCULATE (

COUNTROWS(pbi_identified_and_followup),

FILTER ( ALLSELECTED ( pbi_identified_and_followup ), pbi_identified_and_followup[Index] <= MAX (pbi_identified_and_followup[Index]) ) )

But getting error as "Visual has exceeded the available resources".

I also would like to share that, the number of records are  high (10000+) in the above tables and it keeps increasing in the coming days.

Please guide me on this.

Thanks in advance.

Gurudayal Sahu

[v-luwang-msft]

Hi @Anonymous ,

Could you pls share your pbix file? Remember to remove confident data.

Best Regards

Lucien

[Anonymous · Accepted solution]

Thanks,  Lucien !

I am able to get the Dynamic row number counting now, but it is taking long time after changing any the filter value (defined through the slicer).

In case, we have any better option/approach then please share it.

Thanks and regards,

Gurudayal Sahu

[Anonymous]

Please provide the solution.