Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
stevel
New Member

Formatting SSAS values (Live connection/explore live)

‎02-16-2016 10:34 AM

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.

 

Values Example

 

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?

Message 1 of 25
14,948 Views
0
1 ACCEPTED SOLUTION
greggyb
Resident Rockstar
Resident Rockstar

‎02-16-2016 10:36 AM

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.

Check out the Power BI User Group of Philadelphia
Next meeting: October 5, 2016 Virtual meeting

View solution in original post

Message 2 of 25
18,414 Views
24 REPLIES 24

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All
Top Solution Authors
View All