Visual Calculation is not displayed on Stacked Column Chart

[Anonymous]

Hi,

I've shared a sample report that reproduces the issue here.  The report has a table for Users, Dates, and Cases.  The stacked bar chart in the report has the UserFullName on the X axis, Date Month/Year in the Legend, and the measure [m_CasesClosedCount] on the Y axis.  I then create a Visual Calculation that computes the ratio of the number of cases closed by the user to the average number of cases closed.  If you view the Visual Calculation, you will see that the calculation displays correctly in the matrix displayed:

However, when I go back to the report the Stacked Column Chart visual is blank:

The Stacked Column Chart is not listed on this page as one of the visuals that do not work with visual calculations.  I'm not sure if I'm doing something wrong, if this is just a limitation of visual calculations, or something else.  Any ideas would be appreciated.  Thanks!

[HotChilli · Accepted solution]

The visual calculation has a FORMAT in it so that will be changing the return value to a text value so it won't work.

I haven't looked at it further so you might want to test by getting rid of the format and see if it renders.

[Anonymous]

Hi @HotChilli , thank you so much for taking a look at this.  I hadn't even thought about the FORMAT, but you are correct.  After removing that, the visual renders correctly.  Thanks again for the help, much appreciated!