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.
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.
Measures unformatted. Chart has exact same definition but visualization type is a chart.
@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
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |