Skip to main content
cancel
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
sca4TVD
Helper I
Helper I

KPI Visual in Life connecton doesn't show Percentage

Hi all

 

We have a lot of KPI Visuals displaying Measures formatted as Percentage.

 

All was OK, until the last update of PBI RS.

Since the Update, the KPI Visuals are showing decimal number only, but no Percentage.

Bad Percentage.png

When I look at the Data (Show data) all looks OK

Bad Percentage with data.png

This happens only when I access an SSAS model with a live connection.

When I create a new PBI File in Import modus all looks OK.

Good Display.png

Has anybody experienced this as well?

 

Any help is greatly appreciated.

Salvatore

1 REPLY 1
sca4TVD
Helper I
Helper I

After a few more tests, I found interesting behaviour:

When I install the "regular" Power BI Desktop, and connect to the same SSAS model and use the standard KPI Visual, the value is displayed correctly as a percentage.

When I open a Power BI report, which doesn't display the number in the correct format with the PBI-RS, all looks correct without any modifications.

Screenshot - 22.12.2020 , 10_14_54.png

 

It seems that under specific circumstances, the format string is not processed correctly by the Power BI Desktop for SSRS.

 

Unfortunately, I was not able to reproduce this behaviour in my private test VM with SSAS and PBI-RS (Same version as the customer).

 

Is anybody here from Microsoft, which can help us, or forward this to the product team?

This looks like a bug in the product.

 

Regards

Salvatore

 

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.