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.
I'm running into an issue where I'm not seeing anything that will allow me to format any values I'm pulling from a live connection to a SSAS multidimensional cube.
I would like to format the date in any format in general (01/02/2015, Jan 02, 2015, etc...) and "Cost" would format as $31,519.43 or even $31,519.
Is this possible to do with a live connection to a SSAS data cube?
Solved! Go to Solution.
SSAS is a semantic layer in BI. This means it stores metadata natively with data. Part of this metadata is display formatting. Power View (the report component in Power BI) is designed, for better or worse, to defer to the display format metadata of its source. You should alter these display formats in your SSAS model.
I am seeing for some Visuals they ignore the formatting specified by SSAS MDX. Things like providing 2 decimal points which don't show up in any other client tools.
My experience is that the visualizations Table and Matrix actively uses "Standard" format string on measures that, in the source, are configured without format string. My expectation was "No specific format" (like Excel's "General"). To accomplish the thousand separator and skip decimal places, I set FORMAT_STRING = "#,##0"
Also, even though on live connection, I see that vizualizations like KPI provides the option to specify "Value decimal places" (Format > Indicator).
Hope this is helpful.
^Bump ... Any resolution for this?
Thanks for the info!
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 |
---|---|
111 | |
95 | |
77 | |
69 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |