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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Rank is equal with same numbers, I want random - Any Ideas?

Hello, 

 

I have created a pareto chart with my data, however i have noticed there are occurances where the value o am ranking can be equal for different items I am measuring. This is making the rank equal, and altering my cumulative percentage function. 

 

I would like the equal ranks to be randomly picked, in the screenshot below, I don't care which item is 1st or 2nd, i would just like them to be decided so that the cumulative total will work. 

 

in the screenshot below, my first two items have a result of 155. 

 

I would need:

rank 1 -> cumulative total 155

rank 2 -> cumulative total 310

 

Any ideas?same rank.pngGraph with same rank.png

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@Anonymous 

 

Do you have any column with unique data?

Apply running total on that column and you will get the result you desire.

 

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

 

View solution in original post

2 REPLIES 2
v-xuding-msft
Community Support
Community Support

Hi @Anonymous ,

As nsrshkh1 said, you need a unique column to calculate it correctly. What do you based on to calculate, date or rank you created?  If you still can't solve it, you could post some sample data and the expected result. Then we can help you as soon as possible.

 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

 

Best Regards,

Xue

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

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

@Anonymous 

 

Do you have any column with unique data?

Apply running total on that column and you will get the result you desire.

 

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

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.

Top Solution Authors