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.
Hi,
I am trying to format a number value as currency by selecting the table field on the right hand side and using the formatting options in the 'column tools' tab but all formatting options are greyed out?
(My datasource is Azure Analysis Services)
Thanks
Wayne
Solved! Go to Solution.
Thanks for your responses, I have done the formatting on measures in Azure Analysis Services - its not ideal as PowerBi then treats the currency and percentage formatted numbers as text but works for my current requirements
Thanks for your responses, I have done the formatting on measures in Azure Analysis Services - its not ideal as PowerBi then treats the currency and percentage formatted numbers as text but works for my current requirements
Can I have the solution too? Thanks!
hi @WayneM
For your datasource is Azure Analysis Services, so you must use live connection model.
In this model, you could do any modeling in the power bi, since ssas is a complete data model, all the modeling must be done in ssas, you could only create a report level measure in power bi and do formatting for this measure.
https://radacad.com/live-connection-when-power-bi-comes-hybrid
Regards,
Lin
Hi @WayneM ,
The format would need to be set in Azure Analysis Services. You can get around this by creating a measure that points to that measure you are trying to format. You should then be able to format that.
New Sales = [Sales]
as an example.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
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 |
---|---|
109 | |
100 | |
84 | |
76 | |
65 |
User | Count |
---|---|
120 | |
111 | |
94 | |
83 | |
77 |