Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm importing data that is measured in pennies, but I want to visualise and report on it in pounds. I'm really new to PowerBI so any help would be much appreciated.
I'm sure it should be a 10 sec job for someone, but I literally have no clue where to start.
Many thanks,
Adrian
Solved! Go to Solution.
Hi @adrianm2018,
You should first convert the value calculated from pennies to pounds, then, change the currency symbol.
New a column with DAX:
Pounds = YourTableName[ValueColumn]/100
Best regards,
Yuliana Gu
Hi @adrianm2018,
You should first convert the value calculated from pennies to pounds, then, change the currency symbol.
New a column with DAX:
Pounds = YourTableName[ValueColumn]/100
Best regards,
Yuliana Gu
Thanks for the response @v-yulgu-msft
I created the new column in my table and the DAX formula works perfect. However, when I go back to my graphs I can't change the figures to return data based on the newly created 'Pound' value as I can't find my newly created value within the Currency drop down menu. Any thoughts on how I could do that?
Many thanks,
Adrian
Ah nevermind, i figured it out! Thanks anyway - really appreciate your help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |