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.
Good morning
Another newbie here...
I've started building some financial reporting dashboards in Power BI and want to show the actual vs forecast result for a given month, but when I insert a measure to do this (CYActvsForecast= [CYTotal] - [FcastTotal]), the visual won't display as it thinks there are text values in there somewhere.
As you can see fromt the screenshot below all the values in CYTotal and FcastTotal are numerical, so I don't know what is causing this error! Has anyone seen anything like it before or have any idea how I would go about troubleshooting this?
Many thanks in advance!
Solved! Go to Solution.
@Jillith , You are trying to use sum on a text datatype. Please change the data type and try . Or change in power query
@Jillith , You are trying to use sum on a text datatype. Please change the data type and try . Or change in power query
Thanks for getting back to me. I forgot to mention that both fields used in the variance calculation are measures - the format section does say it is text but all options are greyed out so I can't change anything...
OK - I've got this working by adding value () around my measures used in the variance calculation after searching on why measures are formatted as text/how to change them.
I couldn't find a definitive answer on why this was happening but it's solved now so thank you.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |