Count and display as raw percentages

[Shehang]

HI

Need a help.

See below Table 1 I created in PBI from my data set using count. However I need to display this figures as percentage of the raw.

Exactly like Table 2.

Anybody can help me to do this?

[v-piga-msft · Accepted solution]

Hi @Shehang,

If I understand your scenario correctly that you want to show the value as Percentage?

If it is, after you calculate the value you could set the data format to be Percentage like below.

If you still need help, please share some data sample as table and your desired output in Power BI.

Best Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @Shehang,

I have made a test with your data sample, everthing works as expected.

You could click the fail % column and then click percentage format under Modeling tab.

You also could have a reference of my test pbix which has been attached below.

If you still need help, please share a dummy pbix file which can reproduce your issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

Best Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @Shehang,

If I understand your scenario correctly that you want to show the value as Percentage?

If it is, after you calculate the value you could set the data format to be Percentage like below.

If you still need help, please share some data sample as table and your desired output in Power BI.

Best Regards,

Cherry

[Shehang]

Hi Cherry,

Yellow highlighted "Format percentage" is disabled in Power BI. Not sure its dissabled for PowerBI desktop.

See below Data set and Results I wanted to display.

[v-piga-msft · Accepted solution]

Hi @Shehang,

I have made a test with your data sample, everthing works as expected.

You could click the fail % column and then click percentage format under Modeling tab.

You also could have a reference of my test pbix which has been attached below.

If you still need help, please share a dummy pbix file which can reproduce your issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

Best Regards,

Cherry

[Shehang]

Hi Cherry,

Got the point. I got the count by adjusting properties of each feilds.

But you have got the count using a formula.

Best Regards,

Shehan.

[v-piga-msft · Accepted solution]

Hi @Shehang,

Each way is ok.

Have you solved your problem for percentages format?

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