on 02 Feb 2018 07:40:18
When connecting live to an SSAS source (tabular or OLAP), we should be able to change the displayed format of numbers in the reporting surface (e.g. change # of decimal points, etc). Being able to control how things look in a reporting interface is pretty essential.
For example, in Tableau, you can set the default display formatting of any measure from any data source. That can then be over-ridden (if needed) in specific views (for example, if level of precision needs to dial down to fit on a particular visual, or up, etc.)
- Comments (3)
RE: SSAS Live Connection - Number formatting
This would be a great addition to Power BI.
I have the following issue, which can be solved with this possibility:
The report should show only whole numbers without decimal places. When the measure is formatted in this way, the total will be always calculated based on the base data. But exported data (e. g. from a Matrix) will experience rounding errors and will show wrong totals.
When the measure can provide number with 2 decimal places, but we can set up the measure in Power BI to show no decimal places, then it would be possible to export the data in a correct way.
RE: SSAS Live Connection - Number formatting
Ideally the default format should be pulled from the live connection, but it would be nice if the end user could change it. We have users creating local measures in the report that are simply [My Measure] = [Cube Measure] just so that they can change the formatting.
RE: SSAS Live Connection - Number formatting
The same problem we have with the DATETIME parameter. We only want the date, but because of the restriction this is not possible and in addition, values passed as DATE are formatted in DATETIME, but back to DATE is not possible.....