Infographic designer - fill percentage - sorting multiple values & remove decimals?

[em12963]

Hi 

Could you please help me with these 2 questions:

Question1

I've created some infographics in Power Bi Desktop. I am trying to sort the ProgrammeCode field which has 5 values that I have filtered in the visual level filter. It naturally sorts it alphabetically and numerically ascending wise. 

However, what I would like to do is sort the ProgrammeCode is a customised way; in this case from left AK3693, continued on with AK3619, AK3704, AK3697 and the far most right would be AK3303. . Is that possible?

Question2

How do I remove the 2 decimal places on the text to become zero decimals? The calculated measure is called 'Int funding proportion prog intake EFTS'. 

[v-piga-msft]

Hi @em12963 ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[em12963]

Hi @v-piga-msft 

Thank you for your  explanation.

For Question 2, I will send you the pbix masked file on one drive to look. 

[v-piga-msft · Accepted solution]

Hi @em12963 ,

Question1:

It seems that you want to achieve the custom order for the ProgrammeCode, you could try the feature sort by column. Please refer to this similar thread. 

Question2:

From your image, it seems that you use DIVIDE function to calculate the measure 'Int funding proportion prog intake EFTS' so it should return a decimal number. So why your measure is a text type?

If it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Cherry

[em12963]

Also, thank you for your suggestion in regards to Question 1. I will try to remake a similar table and see whether it works. Cheers