cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ankitapahuja
Regular Visitor

Percentage values not being treated as numeric values

Hi Team,

 

If a column is in a percentage format, plotting it on a graph is not giving the exact values as displayed, rather it is taking the count of rows. It is not treating it as numeric. Please help

 

Thanks,

Ankita

5 REPLIES 5
v-huizhn-msft
Microsoft
Microsoft

Hi @Ankitapahuja,

The percentage column is a calculated column? Or it is a column in resource data? Could you please share more details or sample data for further analysis?

Best Regards,
Angelia

Hi,

 

It is a calculated column in another table and has been merged to the resource data table.

Hi @Ankitapahuja

If it is nomal when calculated column located in another table ? Did you do other operations when merge the table?

Best Regards,
Angelia

Sean
Community Champion
Community Champion

What is the Data Type and also the Format showing - in the Modeling Tab?

 

Percent Format.png

 

 

Hi,

 

Column is in a percentage format

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors