Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a report that shows changes in rates and it's supposed to show up to 10 decimal places, but in powerBi only shows 2.
I am using direct query so can't modify Format (it doesn't give me the option to do so with Direct Mode) , is there's a way to do this?
Please Help
To change the decimal points, you can also go to the Visualisation pane > Format >Specific Column > Value decimal places
HI @Manar.
If you mean change decimal place in directquery mode, you can simply modify it at modeling tab.
For live connection, it is impossible to change it in power query side, you can only modify decimal format at database side.
Regards,
Xiaoxin Sheng
@v-shex-msft Yes I am using live query and in my database the number has 10 decimal places even when I open the Edit query in power bi I see the number with decimals but when I put it in the visual it only shows 2 places!
HI @Manar,
Not so sure why power bi cut down you decimal place, as I said, current you can't modify decimal place in live mode.
Regards,
Xiaoxin Sheng
@v-shex-msft the weird thing is when I click edit query it shows me the number with 4 , 5 and more decimals, but in my report I only see 2 decimal places.
HI @Manar,
Emm, I also not sure why this issue appears, maybe you cna try to contact to power bi support to know more about this.
Contact a Power BI expert today
Regards,
Xiaoxin Sheng
User | Count |
---|---|
94 | |
79 | |
73 | |
63 | |
59 |
User | Count |
---|---|
110 | |
101 | |
84 | |
64 | |
62 |