Report doesnt show the same timeperiod as in Dash Board

[stelllemark]

I have created an "Line and stack column chart" to show number of picked lines and an average of the no. of lined in an order.
It is created in the desktop and looks good.

Then i publize it to the service as ar areport it will only show a smaller timeframe 

If i "pin it" to an Dashboard it will show the sam (correct) timeperiod as in the Desktop.
(please se scrrenshots)

I have tried to change filtering and design but are not able to find why it happen

Report Timeperiod

Dashboard Timeperiod

Desktop Period

So Any ideas??

Desktop timeperiod

[stelllemark]

Tested with the sanme dataset and as several persons have written an fix has been done and now it iis working

[v-qiuyu-msft]

Hi @stelllemark,

You mentioned "Then i publize it to the service as ar areport it will only show a smaller timeframe", but from the screenshots, I havn't found any difference in timeframe. Would you please clarify the issue clearly?

Based om my test, if I create a Line and stack column chart in latest Power BI Desktop(version: 2.35.4399.381), then publish to Power BI Service as an report or pin to dashboard. The report are the same in those three scenarios, and chart will contains same number of columns and display same date values in X-axis. See:

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu

[stelllemark]

Sorry my fault.. Sent the same image twice 😞

Here you can se how it looks for me in the Report and as someone mentioned it seems it only uses 90Ishh rows from the dataset

I also have tried to changes size deletet and do everything that i could thinl off.

[stelllemark]

@v-qiuyu-msft

I also realiased a difference in ypu and mine testing.

Youa re using lees that 97-98 "rows" in the dataset and also ypu are using a hiearchy in the visual The first ine will do so everything works. It is then ou want to display an visual with moore than 100 rows that will trigger the behavior (se @Tishchenko video also)

[v-qiuyu-msft · Accepted solution]

Hi @stelllemark,

I have reproduced the issue like yours. The Line and Stacked Column chart will not display complete dataset records in Power BI Desktop, but in Power BI Service dashboard, the chart will display complete records. It should be a potential bug. I will report it internally and keep you updated once I get any updates.

Best Regards,
Qiuyun Yu

[tuomash]

Hi,
Apparently this has been now fixed? Had the similar issue but now it's ok again

[Tishchenko]

@tuomash I'm not able to reproduce to now.  I'm recorded this video (above this subject) on version 13.0.1100.658, now is 13.0.1100.682. Maybe this is the reason ))

[tuomash]

Yes, apparently that has been fixed to the latest version 13.0.1100.682

[Tishchenko]

I have the same problem  
Some visuals shown ONLY first 99 row from dataset

http://community.powerbi.com/t5/Service/Only-first-99-recods-visuals-in-column-chart/m-p/39265#U3926...

[stelllemark]

I had the feeling that it was showing only parts of the dataset but didnt start counting....