Issue: can you adjust the browser Power BI desktop uses to login to salesforce?
We are trying to connect Salesforce reports using Power BI Desktop. When we are prompted with the salesforce login we use custom domain, and then use SSO login. We are getting an error when logging in that way. We get the same error when trying to login to salesforce through an IE browser. Is there a way to adjust the browser Power BI desktop uses to login to salesforce?Global Text Search and Filter Across All Tables in Power BI
Greetings, Currently, couldn't find a method to enable users to search through every column in every table for a particular text string and promptly filter visuals on the page with corresponding results (Acting like a Search Bar). While workarounds like concatenating columns exist, they're inefficient and impractical for large datasets. Any enhancement facilitating this capability would greatly enhance efficiency and empower users to efficiently delve into their data. Thank you.
Pagination not working correctly with filtering/search in Power BI table (data exists but appears on
Hi everyone, I am new to Power BI and currently learning by building a Worker Status Report. I am facing an issue with custom pagination when filtering/searching data. Report Setup Data source: PostgreSQL Data is retrieved via a database VIEW Visual: Table Page size: 40 rows per page Pagination implemented using DAX + slicer Filters: Date slicer (range) Search (Company / Department / Employee / Team Leader) The data exists in the model, and both date filter and search work, but the issue is with pagination. When I apply filters or search: The table sometimes shows 0 rows However, the filtered data is actually present on page 4, 5, or some other page Pagination does not reset or dynamically adjust based on the filtered result As a result, users think there is no data even though it exists What I expect: Pagination should recalculate dynamically based on filtered rows If filtered data has fewer rows, page count should update automatically Filtered results should appear on page 1, not hidden on later pages Dax used for navigation page navigation table Page Navigation = VAR totalrows = COUNTROWS(vw_worker_status) VAR _pagesize = 40 VAR totalpages = CEILING(DIVIDE(totalrows, _pagesize), 1) RETURN ADDCOLUMNS( GENERATESERIES(1, totalpages, 1), "Min", ([Value] - 1) * _pagesize + 1, "Max", MIN([Value] * _pagesize, totalrows) ) Pagination measure slicer selection = VAR minvalue = SELECTEDVALUE('Page Navigation'[Min]) VAR maxvalue = SELECTEDVALUE('Page Navigation'[Max]) VAR indexvalue = SELECTEDVALUE(vw_worker_status[index_col]) RETURN IF ( indexvalue >= minvalue && indexvalue <= maxvalue, 1, 0 ) This measure is applied as a visual-level filter (= 1) on the table. My Question Why does pagination not adjust when filters/search are applied? How can pagination be made dynamic based on filtered rows, not total rows? Is there a better or recommended approach for pagination in Power BI tables? Should COUNTROWS be replaced with a filter-aware calculation (like ALLSELECTED)? I would really appreciate guidance or best practices. Thanks in advance for your help! https://drive.google.com/file/d/1DjHwOcX_bGAFqFlIzVC-YEXBzbYqHrBh/view?usp=sharingDynamic Inventory Reconciliation: Aligning Opening and Closing Balances in Power BI
I have created an Inventory Reconciliation report that includes a Year slicer. The report's main visual is a matrix with the following rows: Opening Inventory Purchases Sales Closing Inventory (Calculated) On-Hand Quantity The Closing Inventory (Calculated) is determined using this formula: Closing Inventory (Calculated) = Opening Inventory + Purchases - Sales The matrix has Months set on the Columns. For example, if the year 2023 is selected: January’s Opening Inventory is calculated using the following DAX formula: Opening Inventory (Q) = CALCULATE( [On-Hand Qty], PREVIOUSMONTH('Calendar (On-Hand)'[Dates]) ) For February, the Opening Inventory should use January’s Closing Inventory (Calculated) or the previous month's Closing Inventory. Currently, the Opening Inventory row uses its formula to calculate results, which might lead to inconsistencies. I believe the Opening Inventory should instead depend on the Closing Inventory (Calculated) from the previous month. What would be your solution?
Custom Sorting in PowerBI?
Hello all, Seeing as how helpful people were with my last two questions, I thought I'd ask another, which has been nagging me. I'm aware of the sorting function in graphs, but that seems to sort the items alphabetically. What I'm hoping to do is sort non-alphabetically, in an order that makes sense otherwise - highest to lowest, or whatever the case. See here: I'd like it to read Critical, High, Medium, Low. Is there anything I can do here? Thank you!4Q Rolling Average (Cumulative Average) Include 0 value
Dear Team - I am trying to calculate each four Quarter Rolling Average which include 0 value as my formulas does not works well. Its excluding zero value and calculate measure. But i need to include to find each four Quarter Rolling Average. Measure and example attached here. Please guide me. 4Q_AOP$ = VAR __LAST_DATE = ENDOFQUARTER('Calendar'[Date]) VAR __PERIOD = DATESBETWEEN( 'Calendar'[Date], STARTOFQUARTER(DATEADD(__LAST_DATE, -3, QUARTER)), ENDOFQUARTER(DATEADD(__LAST_DATE, 0, QUARTER)) ) RETURN CALCULATE(AVERAGEX ( VALUES('Calendar'[Year-Qtr]), [AOP$] ),__PERIOD)Setting a dynamic Y-axis minimum
Greetings, I have several line and clustered column charts. X-axis = year and monthnumber Y=axis column average cost per stop included corrections DAX: DIVIDE([total costs], [Total stops]) Y=axis line average cost per stop excluded corrections DAX: CALCULATE(DIVIDE([Total costs], [Total stops]), Network[Network] <> "COR") On the page is a pagefilter that shows the last 11 calendar months Each chart has a filter for a specific depot on the dashboard is a slicer where you can select different networks The problem i'm having is the start of the Y-axis. With auto it starts at $0 but when the line is close to the column you can't really see the delta. If i set a specific value it might be to high or to low when switching in the slicer. I wanted to link the minimun to a DAX that calculates 90% of the minimum vallue in the chart and that switches when selecting a different option in the slicer. I tried DIVIDE([total costs], [Total stops]) * 0.9 but ofcourse that was to easy to think of and doesn't work. I can't figure it out. Please help.
Filter Pie Chart by Value Slicer
Hi, I want to merge these 2 pie charts into 1 pie chart. I want to only have 1 pie chart with a slicer for: "Country" and "City". The Details: Date/Year are the same for both pie charts. That means when I click on the "Country" slicer, it will show the left pie chart, count distinct of the number of countries visited in a year, and when I click the "City" slicer, it will show the right pie chart, count distinct of the number of cities visited in a year. Thank you.
