Bar chart Data Label value display error
I am seeing a strange issue here. For months, this report has been working fine and now I see some issues with some records. The below chart shows the sum of the quantity against the Employee Description. As seen in the tool tip, the value should be 0. There are both positive and negative values in the transactions totalling to 0. But instead it displays an exponential number 9 x 10^(−15). However, if I put the same in a table, the total comes to 0, which is correct. But on the bar chart it shows as the exponential value. Has anyone come across this issue? Can it be resolved or is it a PowerBI bug?
Help with Mapbox
I was hoping to find some help about creating custom labels in Mapbox connected to Power BI. I know from looking at the icon map package it is possible to pass values from Power BI to make labels in a Mapbox style, but none of the examples I looked at online explained how I might go about doing that. I was able to do most of what I want when I uploaded a CSV to Mapbox studio, but when I imported the style to power bi the labels just used the csv i uploaded, not from the data table I connected to the map. Any help would be much appreciated.
Data Labels and Formatting via calculation group
Hi everyone, I stumbled across some weird behaviour concerning formatting via calculation items and data labels. So I have a calculation group with two items "None" - applies nothing Expression: SELECTEDMEASURE() Format String Expression: SELECTEDMEASUREFORMATSTRING() "Formatted" - should format the number to millions with no decimal places: Expression: SELECTEDMEASURE() Format String Expression: "#,#0,,.M" Now this calcualtion group does indeed work with e.g. tables but when I want to use this in data labels it does not work, instead it simply adds an "M" at the end of the value, without formatting the value: Are data labels somehow calculated differently? Or could it simply be a bug because of the new features regarding dynamic data labels and such? Perhaps someone here can shed some light! Thank you 🙂Can't turn off data labels once they have been set to 'show: true' in JSON file.
I am working on a JSON file for a custom theme for Power BI. For some of the visuals I have set that data labels should be on. However when I import the theme, I can't manually change this setting in the desktop version. So if I have set the data labels to be on in the JSON file, I can't turn them off manually in desktop version of Power BI. The reverse also happens. If I have turned data labels off in the JSON file, they can't be turned in manually in Power BI. It's only an issue with Data labels. Fx I can turn Total labels and Series labels on/off as I want no matter the settings in the JSON file. The only work-around I found is to go into Data Labels > Apply settings to > and then choose each series and turn off data labels for the series I want. However this is not feasible in settings, where there are many series. I would like to be able to choose whether the Data Labels are on or off by default, but I still need to be able to change it in Power BI for some specific cases of data. Is this a general thing, or is it something specific in my JSON file? I provided an example of the 'labels' section of the JSON file below: Don't know if I should provide the entire JSON file here, as it is quite long? "labels": [ { "show": true, "showSeries": true, "color": { "solid": { "color": { "expr": { "ThemeDataColor": { "ColorId": 0, "Percent": 0 } } } } }, "labelDisplayUnits": 0, "labelPosition": "Auto", "enableBackground": true, "backgroundColor": { "solid": { "color": { "expr": { "ThemeDataColor": { "ColorId": 6, "Percent": 0.2 } } } } }, "backgroundTransparency": 0, "labelOverflow": false, "showAll": false, "fontSize": 8, "fontFamily": "Arial" } ]
