Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Formatting SSAS values with a Live connection - (WAS working until November 2016)

Hello everyone,

 

I have been creating Reports based on a SSAS live connection since a year with calculated measures formatted directly in SSAS with "+#,##0.00%;-#,##0.00%".

 

Data was showing up perfectly with the % in Card, muti-row or matrix tables but I noticed that since December 2016, the formatting is no longer working in Power BI Desktop/Online.

 

Could you please help me out?
Thank you

15 REPLIES 15
v-joto
New Member

^Bump ... Any resolution to this? 

Braggilicious
Frequent Visitor

I've had to raise a premier support ticket on this to get any response from Microsoft.  From the support engineer:

 

"After our local investigation, we found we can actually reproduce similar symptom in our local house. Basically in the backend Power BI will fire DAX queries against Cube directly (we call it DAXMD). At this moment, DAXMD still does not support formatting, so currency does not delegate over. "

Anonymous
Not applicable

Thanks Braggilicious to post the engineer's feedback. He seems to say that formatting from SSAS (from semantic layer) is not supported, but in the example above it shows that before December 2016 the formatting from a SSAS live connection was perfectly working.

 

We can't use any DAX fonctions on top of a live connection. This formatting issue is a big concerns and makes the reporting not user-friendly at all.

 

Let's see if we get help from Microsoft.

 

Thanks for your help guys

Hi @Anonymous,

 

You can take a look at below thread which has the same issue:

Percent display issue in charts in olap live connection

 

For your requirement, you can vote it below:

Better support for SSAS MD formatting

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

@v-shex-msft thanks for your feedback. I voted for that functionality let's hope that it will be accepted and released soon because it's clearly a basic but a must have.

However we are talking here about a fix (at least for the %) and not a new functionality as it was clearly working up to November.

Hi @Anonymous,

 

>>However we are talking here about a fix (at least for the %) and not a new functionality as it was clearly working up to November.

 

This issue has already submit in ICM, but it hasn't fixed at the moment.

 

 

Regards,

Xiaoxin sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

I also just lost SSAS % formatting today which was working ok previously.

Anonymous
Not applicable

@v-shex-msft: do you have an ETA on that fix? It seems that many people are now facing the same issue whereas few weeks ago it was working well. Could you please have someone from MS reach out to me directly? I would be glad to quickly show him the issue.

 

Thanks 

Anonymous
Not applicable

Hello @v-shex-msft, would you be able to follow-up on this topic?

 

I opened a MS ticket and the PBI team said they're aware of the issue. So far we have no ETA and most of all, no workaround.

 

I would have understood if that functionnality had never worked, but here you can't just simply remove a functionnality by mistake and do nothing about it or offer no workaround. Several users have been formatting fields for over a year now!

 

Displaying 3.00 instead of 300% is really confusing for the end-user. This is a fundamental piece for the user adoption of your self service BI.

Hi @Anonymous,

 

As far as I know, this feature is by design and I haven't heard the clear release date from power bi team.

 

Perhaps you can vote the idea to improve the priority of release features:

Better support for SSAS MD formatting

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

Any news on this? I still encounter this issue on a On Premises Power BI Report Server: percentage-formatting in tables is correct, percentage-formatting is other visuals is incorrect.

Any update on this? This issue is now happening in my environment. The formatting used to work in all visuals. Now only table/matrix visuals show the correct formatting from SSAS multidimensional cube.

Anonymous
Not applicable

Hello @v-shex-msft,

 

I don't understand, what do you mean "by design"? Do you mean formatting is not supposed to work or it is supposed to work?

 

Just to be clear: it was working (at least some limited formating options such as Percent or "+#,##0.00%;-#,##0.00%"). I did not change anything (same calculations, same formatting, same cube, same everything). And suddendly I lost the formatting.

 

I'm not asking for a better support for SSAS MD formatting (altough I think it's a great idea and a mandatory feature).

 

I'm just asking the engineers to look at this feature that has been removed. I went over the issue with a Power BI engineer and he clearly noticed that the exact same measure was showing up correctly formatted before in Power BI Desktop + Power BI Online.

parry2k
Super User
Super User

Wow I'm also using SSAS , and not sure about this formatting issue. I'm sure PowerBI team will able to explain it better. Thanks for bringing this up.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

I found a test report created early in September 2016 based on a SSAS live connection where we can see the correct formatting. By chance, that report failed to update since mid-november due to a measure in our cube that no longer exists. But at least it shows that it was perfectly working.

 

On the picture below (sorry for the quality), you can see the formatting of the same measure before and after the December 2016 update.

 

Before-Ater-Dec-16-update.JPG

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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