Created a measure, but cannot change the visualization

[kirby96]

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!

[bsas]

Hi,

Could you provide screenshots of your table(s)?

[kirby96 · Accepted solution]

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)?

[KHorseman]

FORMAT() converts a value to text according to the specified format. It is specifically intended to return a text data type according to the documentation.

Edit: Curse you @TomMartens for being quicker on the draw!

[TomMartens]

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