PBI online - incorrect result displayed - chart with data from a conditional formula

[PBI666]

Hi all,

I have been troubleshooting this strange behavior for the past days without success.

I have a simple chart in PBI Desktop which is showing a correct result but online. 

In APP:

Online:

Whether I build this Age range in Power Query or in DAX, I have exactly the same issue. It is a simple contidional formula which I provivde below. I would not expect a difference in behavior, or is it known that some conditions could "missbehave" with the online version?

I thought it could be related to the data source being interprated differently online, I checked the format of my data in query.

Import an xlsx file from a company sharepoint (so I don't need a bridge)

• Data type (General) with decimal numbers and N/A
• In PBI query:
  • I repalce N/A with a number (22 currently) so I can in the formula for the Age range categorize N/A back and avoid having errors in my Whole number column.
  • Change the type to decimal number
  • Round down & convert to whole number
  • Last thing I did in my troubleshooting: copy the column to ensure I don't have underlaying decimal left over
  • Formula:
    • "Age range(m)", each if [Age for range] = 0 then "0-1 yr" else if [Age for range] = 1 then "1-2 yrs" else if [Age for range] = 2 then "2-3 yrs" else if [Age for range] = 3 then "3-4 yrs" else if [Age for range] = 4 then "4-5 yrs" else if [Age for range] = 5 then "5-6 yrs" else if [Age for range] = 6 then "6-7 yrs" else if [Age for range] = 7 then "7-8 yrs" else if [Age for range] = 8 then "8-9 yrs" else if [Age for range] = 22 then "N/A" else "+9 yrs").

This chart is pulling the data from a single source, no data relationship is used in the chart. Howeve this source of data is mapped to others.

I am a little puzzle by this behavior and cannot figure out if I am doing something incorrect or unsupported by PBI online.

Thanks for anyone who may have a clue.

PBI666

[PBI666]

UPDATE on my previous post:

• I tested my report on a different company environement (I have two licenses and I publish within my company and to my customer)
• The chart is identical as on the desktop app. 🤔

Other Online PBI environement:

If large companies can decide of the lifecycle management, there is little I can influence.

Or could it be to some setting related to the data sets? I use sharepoint sources +SFDC connector.  But the online refresh is 3x per days and works fine.

In the other environment without the issue there is no connection to my data sources, I publish the PBIX to refresh my data.

My impression there is a bug related to the current version used by my company, I am quite certain I saw the chart being correct before. (eg. some field formatting, or source not behaving as in the desktop app)

[v-cazheng-msft]

Hi @PBI666 

Could you please check whether there is any filter on your report that impacts the result displayed on it? If this issue isn’t caused by filters, could you please provide a link of a sample pbix file containing your issue and tell me the version of your Power BI Desktop and Power BI service?

You can check the version of Power BI Desktop by Help>About.

You can check the version of Power BI Service by Help&Support>About Power BI.

Best Regards,

Community Support Team _ Caiyun

[PBI666]

Hi Caiyun,

I am running Version: 2.100.1401.0 64-bit (décembre 2021).

Both online environments have the same version:

Service version13.0.17576.29

Client version2201.4.09695-train

The problem is not coming from the filters (I have two on page level, simple filters based on some text categories), and this behavior is for sure some data format issue.

I am investigating to pre/re-format the source which to me is certainly not handled online exactly the same way as on the desktop version (must be some localisation format, eg. , or . ). I am pretty certain the numbers are not being converted/formatted correctly online vs the desktop.

This source is a XLSL file pulling data with a query from a CSV file (export from PBI).

I'll post again about a status shortly.

Regards,

Cyril

[PBI666]

@v-cazheng-msft 

SOLUTION FOUND:

As suspected the online query doesn't handle (well or not the same) my excel source. 

I simply checked and updated my query and already pre-formated in excel (Whole number and decimal number), this is basically I was doing in my PBI query desktop.

I agree having from the start a well formatted source makes sense.

Cheers.

Cyril

[v-cazheng-msft]

Hi @PBI666 

Noted and thanks for your reply!

Best Regards,

Community Support Team _ Caiyun

[v-cazheng-msft]

Issue is fixed by customer.