Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
TinyElephant
Helper III
Helper III

Add serial number to Slicer List

How can I add a serial number to a slicer list?

1 ACCEPTED SOLUTION

@TinyElephant 

here is a workaround for you

Use DAX or enter data to create an DM table and create a column

Column = rankx(all('Table'[DM]),'Table'[DM],,ASC)&" "&'Table'[DM]

 1.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
ryan_mayu
Super User
Super User

could you pls provide the sample data and expected output?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Something like this showing count of items

TinyElephant_0-1627888950612.png

 

@TinyElephant 

here is a workaround for you

Use DAX or enter data to create an DM table and create a column

Column = rankx(all('Table'[DM]),'Table'[DM],,ASC)&" "&'Table'[DM]

 1.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.