User Profile
ItAccounts
Frequent Visitor
Joined 7 years ago
User Widgets
Contributions
pbiviz start displays "~ /"
Apologize if this is a newbie question, but I am trying to learn Power BI custom visual development. After following the instructions in https://docs.microsoft.com/en-us/power-bi/developer/visuals/environment-setup?tabs=windows and installing the certificate I created a blank Power BI visual using pbiviz new. When I run pbiviz start and go to https://localhost:8080/webpack-dev-server/, I see the following screen: This should display "Update count" if I'm not mistaken. What am I doing wrong?Measure for rolling average by fiscal quarter with filters
I am trying to create a rolling average by fiscal quarter in Power BI and apply filters to a line graph to select only data for a certain date range and display only data for a certain date range. For confidentiality reasons I can’t share the real dataset, so I created a fake dataset that is similar. The dataset is market research survey data and my fake dataset contains three columns: Date, Q1 which is a question asked on a scale from 0-10, and SEGMENT which is either “Segment 1” and “Segment 2”. In my fake dataset I generated random values for Q1 and SEGMENT. The client I am working for uses a fiscal year of November 1-October 31 (so November 1, 2019-January 31, 2020 is Fiscal Q1 2020) and in the real dataset no data was collected for April 1, 2020-July 31, 2020 (Fiscal Q3 2020) due to COVID-19; survey data was collected for all fiscal quarters before and after Fiscal Q3 2020. The issue is that Rolling Q3 2020 is not showing up on my line graph; even though there is no data for Rolling Q3 2020 that data point should still display on the graphs, using the average of all data from Q4 2019, Q1 2020 and Q2 2020. My main dataset is Sheet1 imported from the Excel file Rolling_Quarter_Fake_Data.xlsx. I have created a calendar table CalendarTable which includes all dates between the minimum and maximum date in Sheet1[Date] and added calculated columns DateInt (integer of date), FiscalQuarter, FiscalYear, FiscalYearQuarter, FiscalYearQuarterFormatted and RollingFiscalYearQuarterFormatted. Note that FiscalYearQuarter = FiscalQuarter + FiscalYear*4. I also added the calculated columns DateInt, FiscalQuarter, FiscalYear, and FiscalYearQuarter to Sheet1, and created a relationship between CalendarTable[DateInt] and Sheet1[DateInt]. I am trying to calculate Net Promoter Score = % Promoters - % Detractors; a Promoter is a respondent with Q1 = 9 or 10 and a Detractor is a respondent with Q1 between 1 and 6. Here are the measures I am using to calculate rolling Net Promoter Score: Rolling_Average_Detractors = VAR LastFiscalYearQuarter = MAX(CalendarTable[FiscalYearQuarter]) VAR Filtered = FILTER(ALL(Sheet1),Sheet1[FiscalYearQuarter] >= LastFiscalYearQuarter - 3 && Sheet1[FiscalYearQuarter] <= LastFiscalYearQuarter && SELECTEDVALUE(Sheet1[SEGMENT]) = Sheet1[SEGMENT]) RETURN COUNTROWS(FILTER(Filtered,[Q1]>=0&&[Q1]<=6))/COUNTX(Filtered,[Q1])*100 Rolling_Average_Promoters = VAR LastFiscalYearQuarter = MAX(CalendarTable[FiscalYearQuarter]) VAR Filtered = FILTER(ALL(Sheet1),Sheet1[FiscalYearQuarter] >= LastFiscalYearQuarter - 3 && Sheet1[FiscalYearQuarter] <= LastFiscalYearQuarter && SELECTEDVALUE(Sheet1[SEGMENT]) = Sheet1[SEGMENT]) RETURN COUNTROWS(FILTER(Filtered,[Q1]>=9&&[Q1]<=10))/COUNTX(Filtered,[Q1])*100 Rolling_Average_NPS = [Rolling_Average_Promoters] - [Rolling_Average_Detractors] I am applying two filters to the graph: Sheet1[SEGMENT ] = “Segment 1” because I only want to display Segment 1 data, and CalendarTable[FiscalYearQuarter] to display only data for Fiscal Q1 2019 through Fiscal Q4 2020. Data exists for prior to Fiscal Q1 2019 and is used for calculating the rolling average of earlier quarters, but should not be displayed on the graph. For the measures Rolling_Average_Promoters and Rolling_Average_Detractors I added && SELECTEDVALUE(Sheet1[SEGMENT]) = Sheet1[SEGMENT] to add back the filter on SEGMENT which is removed by ALL. This measure works correctly, but the rolling average for Fiscal Q3 2020 is not displayed. I want that data point to be displayed as I am reproducing an existing report created in non-Power BI software in Power BI. Correct values for Rolling Fiscal Q4 2020 filtered by Segment 1 (data from Fiscal Q1 2020 to Fiscal Q4 2020): Promoters = 1/14 = 7.14%, Detractors = 9/14 = 64.29%, NPS = Promoters – Detractors = -57.14%. Correct values for Rolling Q3 2020 filtered by Segment 1 (data from Fiscal Q4 2019 to Fiscal Q3 2020): Promoters = 1/14 = 7.14%, Detractors = 8/14 = 57.14%, NPS = Promoters – Detractors = -50%. Rolling Q3 2020 is not displaying on the graph right now. I have tried the following solutions which do not work (for detractors measure, promoters measure is similar): Rolling_Average_Detractors = VAR LastFiscalYearQuarter = MAX(CalendarTable[FiscalYearQuarter]) VAR Filtered = FILTER(ALL(Sheet1),Sheet1[FiscalYearQuarter] >= LastFiscalYearQuarter - 3 && Sheet1[FiscalYearQuarter] <= LastFiscalYearQuarter) RETURN COUNTROWS(FILTER(Filtered,[Q1]>=0&&[Q1]<=6))/COUNTX(Filtered,[Q1])*100 This works correctly and Rolling Fiscal Q3 2020 is displayed, but this removes the filter on SEGMENT. Rolling_Average_Detractors = VAR LastFiscalYearQuarter = MAX(CalendarTable[FiscalYearQuarter]) VAR Filtered = FILTER(ALLEXCEPT(Sheet1,Sheet1[SEGMENT]),Sheet1[FiscalYearQuarter] >= LastFiscalYearQuarter - 3 && Sheet1[FiscalYearQuarter] <= LastFiscalYearQuarter) RETURN COUNTROWS(FILTER(Filtered,[Q1]>=0&&[Q1]<=6))/COUNTX(Filtered,[Q1])*100 This does not work properly and causes incorrect values to be displayed on the graph. Rolling_Average_Detractors = VAR LastFiscalYearQuarter = MAX(CalendarTable[FiscalYearQuarter]) VAR Filtered = FILTER(ALLSELECTED(Sheet1),Sheet1[FiscalYearQuarter] >= LastFiscalYearQuarter - 3 && Sheet1[FiscalYearQuarter] <= LastFiscalYearQuarter) RETURN COUNTROWS(FILTER(Filtered,[Q1]>=0&&[Q1]<=6))/COUNTX(Filtered,[Q1])*100 This does not work correctly if a filter is applied to the graph displaying only Q1 2019 to Q4 2020. What happens is that the rolling average for earlier quarters is calculated only including data from Q1 2019 and later. For example, the rolling average of Q1 2019 includes data from Q2 2018, Q3 2018 and Q4 2018 as well as Q1 2019 but if I use ALLSELECTED then it is excluded. See pbix file and Excel file posted to OneDrive: https://1drv.ms/u/s!AtKO3f2K35FzkfROX_Z5pmHMbKQqPA?e=EWDyDp Does anyone have any ideas?Use font sizes not in dropdown list in text box
It should be possible to create a text box with a font size not in the dropdown list in an easier way. Right now it is not possible to select font sizes not in the list, e.g. the dropdown list gives options of 8, 9, 10, 10.5, 11, 12, 14 etc. but what if I want 13 point font in order to make a label fit in a report? It is possible to do this by opening up a document in Microsoft Word, entering your text and setting font size to 13, and then pasting into Power BI. It should be possible to set a custom font size directly in Power BI like it is in Word.Can't change data colors of graph when there is no data
It is not possible to change the "Data colors" of a graph (currently using 100% stacked bar chart) when there is no data but data labels appear on the legend (when the "Show items with no data" option is enabled). See example of a graph like this above; I am using a measure in "value" that filters by date. The data colors option disappears from the formatting pane in this case. Currently using version 2.79.5768.721 64-bit (March, 2020).Re: Power BI high memory consumption when creating measures
I split a large report into 6 smaller reports and this problem went away, because each smaller report has fewer measures in it. The performance of the built-in Power BI measure editor is very poor, especially when a report contains a large number of measures. The built in measure editor still is not very fast after splitting up the report, but at least it does not use up so much memory that it causes Power BI to lock up. I have started using Tabular Editor https://www.sqlbi.com/tools/tabular-editor/ to edit measures outside of Power BI because the built in measure editor is poor when editing large numbers of measures. Microsoft needs to improve its built in measures editor (one of the highest voted ideas for Power BI) and the Tabular Editor can provide some ideas for Microsoft. It should not be slow to edit measures or cause high memory consumption; is Power BI recalculating every measure in the report every time I add or edit a measure? There should be no need to do this.Power BI high memory consumption when creating measures
When creating measures in Power BI it causes Power BI's memory consumption to increase dramatically. I have a fairly complex model with several hundred measures and after opening the file and creating a couple of simple measures, it causes my memory consumption to soar - I've seen Power BI use up to 11GB of memory (and start swapping) on a computer with 16GB of memory installed. The result is I need to enter a few measures, close and restart Power BI, and enter more measures until I have finished editing measures. The dataset comes from a web survey and there are several dozen questions in the questionnaire, and each page requires about 10 similar measures to be created for each question. Is there any way to avoid this problem? Is there any way to edit measures outside Power BI and import them into Power BI, or edit them using an external tool? As far as I can tell, tools like DAX Studio can only view measures and run queries, but not edit the content of the PBIX file.report.print() does not print entire iframe, some parts are missing.
I have an asp.net page. I am embedding my powerbi report: var config = { type: 'report', tokenType: 1, accessToken: token, pageView: 'fitToWidth', embedUrl: embedurl, id: reportid, permissions: 7, settings: { filterPaneEnabled: true, background: 0, //set 1 to remove grey background. navContentPaneEnabled: true, layoutType: 1, customLayout: { displayOption: 2 } } }; var reportContainer = document.getElementById('reportContainer'); var report = powerbi.embed(reportContainer, config); I have print button: <button type="button" class="btn btn-danger dropdown-toggle" style="margin-left:3px;" onclick="myfunction()"> <span> Print page </span> </button> and function to print: function myfunction() { var repcon = document.getElementById('reportContainer'); var rep = powerbi.get(reportContainer); rep.print(); } My problem is, it is not printing all the iframe but a part of it only, like 300% zoomed-in print. Same problem with this person: https://stackoverflow.com/questions/42049025/embedded-media-on-iframe-zooms-in-windows-print/42052175#comment96884311_42052175 I am using Chrome. Could not find a way to handle it. Also explained here: https://stackoverflow.com/questions/55067770/how-to-disable-mediaprint-while-printing-content-of-iframe Any help would be appreciated. Regards.
