BUG : Box and Whisker chart visualisation not working for SSAS cube, calculated measures.

[inayatkhan]

Box and Whister chart ( the orange and blue icon) from Market place does not show calcualated measures from the cube, however it does show regular measure group measures correctly. 

In the lower row , the two visuals , the regular measure Fact Invoices Receivable Count is displayed correctly in both Box and Whisker Chart and the Matrix.

In the upper row , the matrix visual correctly shows Invoice Amount Budget, but the Box and Whisker chart does NOT show chart correctly.  highlighted in yellow and circled with a blue line.

This is the calculation in the Cube's calculations script 

CREATE MEMBER CURRENTCUBE.[Measures].[Invoice Amount Budget USD ]
AS [Measures].[Invoice Amount Original Currency] * [Measures].[Exchange Rate],
VISIBLE = 1 ,
FORMAT_STRING = '#,#0';

Please test this using a direct conection to SSAS cube to possiby AdventureWorks.

This is using SSAS Direct connect mode. 

My SSAS cube has been built with Visual Studio 2015 Version 14.0.25420.01 Update 3.  It is running on SQL server analysis services version 3.0.4206.0.

[v-qiuyu-msft]

Hi @inayatkhan,

As the custom visual is authored by Jan Pieter Posthuma, I would suggest you contact the Jan Pieter Posthuma for help via sending email to mail@datascenarios.nl as suggested here( You can find many contact methods on the top right corner of this page)

Best Regards,
Qiuyun Yu