Landing users to the Feedback tab for survey entry in PowerApps
I have a last tab for the survey in my BI report and I want users to directly go to last page for feedback and get back to the current page after feedback.For feedback i am using PowerApps. How to move directly from First or current page to tha last and get back to current page.
Power bi paginated reports matrix total of filtered row group
Hi, I have created a matrix in the paginated report. I created a row group in the matrix where I am showing the sales (sum(sale_amount) for only those products who sold atleast 100 quantities or more in the current month. The filter on the group is count(items) >= 100. This works fine and gives the desired result. Now we wanted to add a total to this group to see the total sale amount. The problem with the total is that it shows the total sales of everything that is sold in the current month. I want the total to only total the sale of the group where the filter is count(items) >= 100. Can someone please give me a solution to this. Regards
Report Builder - Unable to get row/column header to appear on new page
Just a little background on what I'm doing as this is not a typical tablix set up. I am designing a page that prints the cell values vertically because I need it to be in landscape and not portrait. I know I can select report type to change from portrait to landscape but the report has a mix of both portrait and landscape oriented pages within it. I do not believe report builder can do both in one report, (I'd be happy if I am incorrect in this fact - please let me know) so therefore I am resorting to designing the landscape page vertically in portrait mode, so that the landscape pages can be included in the report that is printed in portrait mode. Below is an example of what I want the report to look like but unfortunately I have not found a way to do that in report builder. I thought for awhile about how to build a landscape page in report builder that only lets you do all the pages in portrait or landscape. So to achieve this, I am converting the landscape page in a portrait oriented environment. I've taken the following steps: Using the property "WritingMode" and setting that to "Rotate270". - This prints all the text vertically. **Everything seems fine except I cannot get the headers to repeat on a new page. I am a little confused on this part, perhaps someone with more experience can explain this to me better... is the cells in blue (see tablix below) that I want to repeat on each new page considered column headers or row headers? I've tried setting the two static cells under the "Row Group" to "Repeat on new page" found in the bottom left corner of the "Advanced Mode" but that doesn't seem to get the cells in blue - "Steps + Location" headers to print on the new page. This shows the output but the page breaks do not include the column header in blue I've also tried to set the static cell in the column group under the advanced mode to "RepeatOnNewPage" but I get this error when I do that. The tablix 'Tablix2' has an invalid TablixMember. All TablixMember elements in a TablixColumnHierarchy must have the RepeatOnNewPage property set to false. The definition of the report '' is invalid. An error occurred during local report processing.I want to setup power bi on premises, also connect with react, with out using any internet.
I have project for that i connect my power bi to azure ad, after that i have embed power bi report in react, i have generate access token and manage there dataset refresh using power bi apis, its working fine completely, now i have another client that want to setup all this locally like as a software on there pc, i just want to know is it possible to stup power bi locally, and embed with react locallly like without using the internet, everthing will be work on local port, also if its possible to refresh report and generate token locally through react. please give me the better ans for that and kind of better solution that help me out for this.Simplifying slicer filter scenarios in a measure
Hi I was wondering if there might be a way to simplify my measure such that I don’t need to specify every slicer filter that needs to be unselected/off for the hard-coded ‘Year count’ scenarios to occur. Sum of SUMX CN-Q code targeted count with hard-coded Year totals final v2 = SWITCH( TRUE(), ([SelectedYear OrderAsc] = "21/22") && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[FT or PT]) = False) && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[Level]) = False) && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[Campus]) = False), "4892", ([SelectedYear OrderAsc] = "22/23") && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[FT or PT]) = False) && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[Level]) = False) && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[Campus]) = False), "4511", ([SelectedYear OrderAsc] = "23/24") && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[FT or PT]) = False) && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[Level]) = False) && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[Campus]) = False), "4853", ([SelectedYear OrderAsc] = "21/22, 22/23") && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[FT or PT]) = False) && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[Level]) = False) && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[Campus]) = False), "9403", ([SelectedYear OrderAsc] = "21/22, 23/24") && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[FT or PT]) = False) && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[Level]) = False) && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[Campus]) = False), "9745", ([SelectedYear OrderAsc] = "22/23, 23/24") && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[FT or PT]) = False) && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[Level]) = False) && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[Campus]) = False), "9364", ([SelectedYear OrderAsc] = "21/22, 22/23, 23/24") && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[FT or PT]) = False) && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[Level]) = False) && (ISFILTERED(Main_Inc_CC_And_tfs_SurveyResults[Campus]) = False), "14256", [Sum of SUMX CN-Q code targeted count] ) SelectedYear OrderAsc = CONCATENATEX( VALUES(Main_Inc_CC_And_tfs_SurveyResults[ShortYear]), Main_Inc_CC_And_tfs_SurveyResults[ShortYear], ", ", Main_Inc_CC_And_tfs_SurveyResults[ShortYear], ASC ) Also so that I don’t need to update the measure scenarios everytime I add new slicers to my report page. I hope that's makes sense. Please let me know if you have any questions. The source data and powerBI files are available via the following links: AnonReportq_ns_ts_v1.pbix AnonReportq_DataSrc_v4.xlsx ReturnsData_21_22_to_23_24_Test_v1.xlsx Any help would be really appreciated. Best Wishes JFarq Also for your reference: Sum of SUMX CN-Q code targeted count = CALCULATE ( [SUMX CN-Q code targeted count], ALLSELECTED(Main_Inc_CC_And_tfs_SurveyResults[CN-Q code]) ) SUMX CN-Q code targeted count = SUMX( ReturnsData_21_22_to_23_24, [CN-Q code targeted count]) CN-Q code targeted count = CALCULATE ( SUM ( ReturnsData_21_22_to_23_24[Targeted] ), FILTER ( ReturnsData_21_22_to_23_24, ReturnsData_21_22_to_23_24[CN-Q code] == MAX ( Main_Inc_CC_And_tfs_SurveyResults[CN-Q code] ) ) )
informes power bi
Necesito ayuda, como hacer que los usuarios que no tienen licencia Power BI puedan visualizar los informes realizados por mi que si tengo licencia de Power BI, y los usuarios de la organización tienen licencia oficce 365 donde está la versión gratis el Power BI y cuando lo activaron por 60 días de prueba y ahora que ha pasado ese tiempo ya no permite visualizar los informes. y les sale el siguiente mensaje:
