Forum Discussion
Created a measure, but cannot change the visualization
Hello-
I've created a new measure that calculates a weighted average calc on two columns in my dataset. When I create a table visualization of this measure, the calc is working fine, but I'd like to change the visualization to a chart (line or bar or something).
However, when I select any visualization other than a table, nothing is displayed. Am I missing something basic, or is there something about my calc that is precluding seeing the results in a chart?
Thanks!
Solved:
It appears that the FORMAT function that took my SUMX formula as an argument limited the results to text, although I was using a format of "0.00%" (i.e. it's somewhat counterintuitive, but I'm guessing the quotes suggest it remains text).
When I removed the FORMAT function and then changed format of the visualization itself (in the modeling tab), it worked just fine.
Is that the correct intrepretation of what happened here (I'm pretty new)?
4 Replies
bsasPost Patron
Hi,
Could you provide screenshots of your table(s)?
Solved:
It appears that the FORMAT function that took my SUMX formula as an argument limited the results to text, although I was using a format of "0.00%" (i.e. it's somewhat counterintuitive, but I'm guessing the quotes suggest it remains text).
When I removed the FORMAT function and then changed format of the visualization itself (in the modeling tab), it worked just fine.
Is that the correct intrepretation of what happened here (I'm pretty new)?
- TomMartens
Super User
Hey,
yes that is expected due to the fact, that the DAX function FORMAT() returns a string:
https://msdn.microsoft.com/en-us/library/ee634924.aspx
If the result of FORMAT(...) can be interpreted as a numeric value you might give this a try
VALUE(FORMAT(...,theformat))
Regards
