User Profile

David_Schrag

Regular Visitor

Joined 8 years ago

4 Posts

View All Badges

User Widgets

Contributions

Width of Power BI report embedded in SharePoint Online
I've successfully embedded a Power BI report in a SharePoint page following the instructions at https://powerbi.microsoft.com/en-us/documentation/powerbi-service-embed-report-spo/. However, my report appears rather square and there's a lot of white space to the right of the report. I'm displaying the filter pane, and when the pane is revealed the report text gets very small. So I'd like to take advantage of all that extra space on the right. I've tried setting the display ratio to 16:9, but the Display box just stays blank: I've tried changing the settings in both Chrome and Edge. 1) If I were successful in getting the display ratio to stick, would that solve my problem about the extra white space? If so, what can I do to apply that setting? 2) Is there a different solution to the white space problem that has nothing to do with the display ratio? For example, is there a way of manually editing the iFrame width in a Power BI web part?
Solved
8 years ago Place Service
Need Help
19KViews
0likes
1Comment
Re: missing data
Yes, that was very helpful and gave me what I needed. Your solution relies on the modeling function within Power BI Desktop to create the Calendar table from data contained in the Data table. Is modeling like that possible using the Power BI Service? The ultimate goal is to use source data that's contained in OneDrive for Business and present the report on-line, either natively within powerbi.com or embedded in our SharePoint Online environment (in an Office 365 Group site). I can publish the .pbix file to the workspace, so I have a way of sharing the data, but I don't think I can take advantage of the auto-refresh that way. (I'm very new to Power BI, so maybe this is a dumb question.)
8 years ago Place Desktop
4.3KViews
0likes
1Comment
Re: missing data
This is highly oversimplified, but imagine the data is something like this: Date InvoiceAmount Quarter 15Jan2016 500 2016-01 15Feb2016 250 2016-01 31Aug2016 1000 2016-03 30Nov2016 1500 2016-04 To get the value for quarter, I have extracted the year and quarter values from the Date column, transformed them into text, and then concatenated them using the Merge Columns feature. When I aggregate by quarter, I have sales of 750 in 2016-01, 1000 in 2016-03, and 1500 in 2016-04. If I graph that, sorted by quarter, it will look like a steadily climbing line from left to right. But note that there are zero sales in Q2. I want my graph to dip from 750 to zero for Q2 and then go back up again for Q3. How do I tell Power BI to display a value for 2016-02 even though there are no data points to aggregate for that time period?
8 years ago Place Desktop
4.3KViews
0likes
3Comments
Re: missing data
I have the same kind of issue as the original poster. I have many months of customer purchase data, which I have aggregated by quarter (2016-1, 2016-2, 2016-3, etc.). I want to create a line chart visualization that displays every quarter between 2015-1 and 2017-4, including quarters where the total purchases were zero. But I don't have any records in my database when there were no purchases. I can easily create a table that contains a record for every quarter in the time period, but how would I create a relationship between that table and my purchase records table that would force a zero value to display for a given quarter when there are no matching purchase records? None of the join options seem to do this.
8 years ago Place Desktop
4.3KViews
0likes
5Comments

Data Privacy

Microsoft Fabric Community and Privacy

To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.