DAX formatted calculated measure SSAS Tabular live connection has no values in chart

[Anonymous]

When I use DAX FORMAT function to set the data type/format for a calculated measure in Live connection mode to SSAS tabular, the Calc measure no longer appears in the Chart.

• Create new report with Live Connection to SSAS Tabular cube
• Create custom calc and create report.

Measures unformatted.  Chart has exact same definition but visualization type is a chart.

 

• Update Measure to include DAX Format function to change measure formatting
• Series for updated measure is now gone from the chart.  Values in table are updated and correctly formatted.

[v-haibl-msft]

@Anonymous

After you using DAX to format the measure, its data type will not be Decimal Number anymore. Then the chart will not be able to show the non-numeric fields.

Actually you can define the currency symbol directly in the ribbon as following screenshot.

Best Regards,
Herbert

[Anonymous]

Hi Herbert,

I am aware of the formatting options in the Modeling ribbon.  However, the formatting does not stay after you close PowerBI Desktop ( I logged an issue here http://community.powerbi.com/t5/Issues/May-2017-Release-calculated-measures-on-live-connection-issue... )

I am only using the DAX FORMAT() function because I could not get the ribbon based data formats to work.  I don't need it to be "Currency" format actually, I was trying to use a custom data format mask "#,##0;(#,##0)"  This works for formatting the values but renders the value unuseable in the chart.

[v-haibl-msft]

@Anonymous

The fix for the formatting not stay issue will be fixed in the June 2017 version of Power BI Desktop.

The custom data format mask cannot be used in the chart, because it can only show for numerical values.

Best Regards,
Herbert