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.
In addition to the shifting decimal places bug I logged yesterday, I've found more bugs with displaying currency measures in the Power BI service, when connected live to a multidimensional cube vie a data gateway.
For these examples, the data type for the Money Measure in SSAS is "Currency", and the values are:
Test SID, Money Measure
1, 1000.50
2, 1234.56
3, -999.99
Negative values are shown as absolute values, regardless of the visual. In the screenshot below, the "Money Measure" value for Test SID 3 is -999.99.
Note that the decimal places are also incorrect, as described in the shifting decimal places bug. Power BI seems to be trimming all trailing zeroes, then placing the decimal point four positions from the end of that number.
Note also that the sorting (and filtering) uses the correct values; in the table in the above example, the rows are sorted largest-to-smallest according to the raw data in the cube.
Can someone of the Power BI team please look at this? This makes live connections to SSAS multidimensional completely unusable.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.