cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jasonbub_work Frequent Visitor
Frequent Visitor

Card on PowerBI Online NOT Respecting Defined Decimal Place

Hi,

 

I have a Report that has been working for sometime.  Today when I went in, the Cards that I have setup to to show Max, Average and Min of a Measure started showing many Decimal places.  The Card's Format Settings > Data Label are set to Display: Auto.  I tried to manually set them to 2 decimal places, but this DID NOTHING.  I also tried to specify Millions and Billions and this still didn't get the to respect the defined Decimal places.

 

Here is a picture.

decimal.png

 

Any ideas?

Jason

7 REPLIES 7
greggyb New Contributor
New Contributor

Re: Card on PowerBI Online NOT Respecting Defined Decimal Place

Make sure you submit this as a bug report, as well. You can do so in PBI Desktop by using the 'Send a frown' option in the File menu, and using the feedback menu in PBI Service.

The forums are a great avenue for discussing issues, sharing thoughts / ideas, and troubleshooting, but they are not the official medium to submit bug reports.

Proper bug reports will receive more attention from the devs than forum posts.

 

 

Beyond that, have you set the measure's formatting?

jasonbub_work Frequent Visitor
Frequent Visitor

Re: Card on PowerBI Online NOT Respecting Defined Decimal Place

Hi Greg,

 

Aside from setting the Formatting > Data Label > Decimal places, how else can I control the Measure's formatting?

 

The data source is set an Excel document that is stored in a SharePoint Group and updated using PowerQuery.

 

Jason

greggyb New Contributor
New Contributor

Re: Card on PowerBI Online NOT Respecting Defined Decimal Place

The visualization pane in your screenshot controls formatting in a specific visualization. It does not alter the defined formatting for the measure.

Capture.JPGMeasure selected in fields pane on right. Measure attributes under Modeling ribbon menu.

jasonbub_work Frequent Visitor
Frequent Visitor

Re: Card on PowerBI Online NOT Respecting Defined Decimal Place

Hi Greg,

 

Thanks for taking the time to reply to my post and include a screenshot.  It is very much appreciated.

 

I am currently using the PowerBI Online (app.powerbi.com) to connect to my data source that is stored in a SharePoint Group folder (associated with my Office 365 Group that the PowerBI is published to) as I haven't been able to get a PowerBI Published report to successfully update anything else after publishing.  So, long story short, I only have the options available to me using the online tool and editing the model/measures isn't something that I can find a way to do online.

 

My current process is as follows:

  1. Create an Excel document with my data
  2. Using PowerQuery, fetch and transform the data as necessary.
  3. Save this document to the SharePoint site folder associated with the Office 365 Group that I am sharing the PowerBI dashboard with.
  4. Go to PowerBI online
  5. Click Get Data > Files > OneDrive - Group - "Name of Group" > click the saved File in the OneDrive for Business > click Connect
  6. Click Import under the Import Excel data into Power BI
    powerbi-import.png

This process creates a connected data source that is successfully able to get updates when I make them to the Excel document.  I haven't been able to accomplish refreshing an Excel data source any way using Power BI Desktop (interested if you have suggestions).

 

Jason

greggyb New Contributor
New Contributor

Re: Card on PowerBI Online NOT Respecting Defined Decimal Place

That's a whole lot of other problems. My first suggestion is to send feedback using the feedback menu options from PBI Desktop and PBI Service when those processes fail. You should be doing your model development in Excel Power Pivot or Power BI Desktop data model. If you get failures or errors when using those tools to upload a dataset and/or report to PBI Service, those are the problems to address.

jasonbub_work Frequent Visitor
Frequent Visitor

Re: Card on PowerBI Online NOT Respecting Defined Decimal Place

Thanks Greg.  I wish I lived in Philly, as I'd stop by your user conference.  Got an affliates in Los Angeles?

greggyb New Contributor
New Contributor

Re: Card on PowerBI Online NOT Respecting Defined Decimal Place

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 538 members 4,376 guests
Please welcome our newest community members: