Table Sorting issue with a column with percentage value

Power BI
1

Hi All,

I have a table in power bi, with columns like names , cities and one measure which has say percentage calculation (divide formula) which ranks 0 to100 % based on few criteria, the problem is my table set is not working properly - its not getting sorted 0 to 100 % and most times few cities with 0% are coming above and below - its not like all 0% above and 100% at the bottom, please help on this

2

Hi @AbhinavKumar,

Could you please share your sample file and the screen shot with the current and expected output.

Please check the data type(decimal,whole number) of the column which might affect your output .

Thanks
Mukesh

3

Hi @AbhinavKumar , we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.

  • Use the forum search to discover if your query has been asked before by another member.

  • When posting a topic with formula make sure that it is correctly formatted to preformatted text </>.
    image

  • Use the proper category that best describes your topic

  • Provide as much contextn to a question as possible.

  • Include the masked demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

I also suggest that you check the forum guideline https://forum.enterprisedna.co/t/how-to-use-the-enterprise-dna-support-forum/3951. Not adhering to it may sometimes cause delay in getting an answer.

Please also check the How To Mask Sensitive Data thread for some tips on how to mask your pbix file.

4

Hi @AbhinavKumar, we’ve noticed that no response has been received from you since the 29th of January. We are waiting for the masked demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details. This will help other users and experts to answer your inquiry better. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

5

@AbhinavKumar,
please check whether you are sorting with another column other than your selected column.

6

Hi All,

The issue identified was number and text issue in same column, which was resolved after sometime thanks all for suggestion and support , please mark as closed.