cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JezMazter
Frequent Visitor

Percentage values in powerquery showing up as decimal in report view

Hello,

 

I have values in percentage format which I wish to show in report view. Despite being in percentage formant in powerquery, in the report view the values show up as decimal.

In power query:

rejection.png

 

In Report view:

Screenshot 2023-02-22 161915.png

Screenshot 2023-02-22 161952.png

 

Thank you in advance.

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

In the model view of the table, select the column and change the formatting selection:

jdbuchanan71_0-1677080676074.png

 

View solution in original post

3 REPLIES 3
JezMazter
Frequent Visitor

Thanks! It works! 🙂

jdbuchanan71
Super User
Super User

If you are showing a measure instead of the column you can change the formatting option of the measure as well.

jdbuchanan71_0-1677080863103.png

 

jdbuchanan71
Super User
Super User

In the model view of the table, select the column and change the formatting selection:

jdbuchanan71_0-1677080676074.png

 

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