Power BI Desktop -Problem With Webview 2
I am using an MSI laptop with an AMD Ryzen 5 7000 Series processor and 16 GB of RAM. Over the past week, I have been experiencing issues with Power BI. When I open two or more PBIX files, the application crashes, and occasionally it throws an out-of-memory error. ATF for your reference.
Conditional formatting for matrix column headers based on closed month
Hi all, I am working with a Power BI matrix where I have months (January–December) displayed as column headers, as shown in the screenshot. no value will display, only the column Kindly ask for below request solution Dynamically change the background color of the column headers If a month is financially closed → show green If a month is still open → show grey I have a DAX in my model (e.g., a measure or flag indicating whether a month is closed): Closed Month Flag = IF( SELECTEDVALUE('Time'[IsClosedMonth]) = TRUE(), 1, 0 ) so the challenge is only related to applying the formatting to the headers. Thanks for support!
Help with DAX when Multiple measures are used in Matrix
Hello All, This is very easy & silly DAX mistake I am doing, new to DAX so need your help to acheive the result. Attaching my sample pbix file here PowerBi Sample . If you see there I have a matrix visual where i have used multiple measures to calculate the count of cases on few conditions. Issue is when i click onany of the columns value belos printed table doesn't filter it properly. It is showing total row values. I want if i click on App team's implementation value, Table also show only those lines. Please help me with this asap. Thanks in Advanceidentifying active users every month
Hi, I have a list of users every month, and i need to find the active users in every month. maybe by creating a new calculated column which states if the user is active or not - If the user names present in the next available month file then those user names are active or - if a new user appears for the very first time which are not available in any of the month files then they are active from that month onwards. Please note if user names not appearing continuously then they are inactive. please find the data like below: column names are: System user name,Count of System user name,Sum of cost,Monthly Source file Name System user name Count of System user name Sum of cost Monthly Source file Name User_A 3 € 112.50 24-Jan User_A 3 € 112.50 24-Mar User_A 3 € 112.50 24-Apr User_A 3 € 112.50 24-May User_A 3 € 112.50 24-Jun User_A 3 € 112.50 24-Sep User_B 7 € 149.50 24-Mar User_B 7 € 149.50 24-Apr User_B 7 € 149.50 24-May User_B 7 € 149.50 24-Jun User_B 8 € 238.50 24-Sep User_C 5 € 139.50 24-Jan User_C 7 € 151.50 24-Mar User_C 7 € 151.50 24-Apr User_C 7 € 151.50 24-May User_C 7 € 151.50 24-Jun User_C 7 € 151.50 24-Sep User_D 12 € 323.00 24-Jan User_D 13 € 329.00 24-Mar User_D 13 € 329.00 24-Apr User_D 13 € 329.00 24-May User_D 13 € 329.00 24-Jun User_D 14 € 332.00 24-Sep User_E 5 € 138.50 24-Jan User_E 7 € 209.50 24-Mar User_E 7 € 209.50 24-Apr User_E 9 € 222.50 24-May User_E 9 € 222.50 24-Jun User_E 9 € 305.00 24-Sep User_F 11 € 362.50 24-Jan User_F 13 € 374.50 24-Mar User_F 14 € 380.50 24-Apr User_F 14 € 380.50 24-May User_F 14 € 380.50 24-Jun User_F 14 € 463.50 24-Sep User_G 6 € 219.50 24-Apr User_G 7 € 226.00 24-May User_G 6 € 219.50 24-Jun User_G 7 € 246.50 24-Sep User_H 3 € 112.50 24-Mar User_H 3 € 112.50 24-Apr User_H 3 € 112.50 24-May User_H 3 € 112.50 24-Jun User_H 3 € 112.50 24-Sep How do i create this Active users list every month using the above data in power bi?? Thanks in advance for the helpFiltering by histogram bins in Power BI
Hi Everyone, In Power BI I have created a histogram that shows Number of People per Attendance Rate. To do so I have created additional table that defines the ranges for the histogram, which looks like this: HistogramBins: IDBinMaxMin 1 0-20% 0.2 0 2 20-40% 0.4 0.2 3 40-60% 0.6 0.4 4 60-80% 0.8 0.6 5 80-100% 1.01 0.8 Then I created the measure that would count how many people falls into each range by Attendance rate: Number of people per range = VAR minbin = SELECTEDVALUE('Histogrambins'[Min]) VAR maxbin = SELECTEDVALUE('Histogrambins'[Max]) VAR segment = FILTER( ADDCOLUMNS( SUMMARIZE('People', 'People'[ID]), "@Attendance", [% Attendance rate]), [@Attendance] < maxbin && [@Attendance] >= minbin) RETURN CALCULATE([Number of People], segment) It works nice for the Histogram itself, but I would like to add the option to click on Histogram bins and to have the rest of the report filtered for People[ID] that fall into each range. In the report I have slicer with Period (which is selected to show last 6 months) and an overview of Attendance rate per month which uses the measure % Attendance rate: % Attendance rate = DIVIDE ([Number of People]), [Number of Invitees]). It works when I am not filtering by histogram bins. I have tried to use CONCATENATEX list of People ID and then to filter the meausre by CONTAINSSTRING using People ID from the People table that is connected to People ID in the Attendance table, but when I click on specific bin, in the overview by month, it omits the months when Attendance rate falls below selected range per this month. I would like to separate somehow the inital range of Attendance rate from the second calculation of the Attendance rate so when I, for example, click on range 80-100% I would see the overview for people that fall into this range for selected period, even if for some months in the selected period, it falls below 80%. Would appreciate any help or hint.
Unable to Find Visual Option in “Format Visual” Section in Power BI
Hi Team, I am trying to develop a custom combo area line chart, but I am not able to see the "visual option" in the “Format Visual” section beside “General.” Can you please tell me how I can get the visual option in Power BI Service or Desktop?Column Name Changes Every Month
Hello Everyone, This Data set has multiple columns where in Column 7 to Column 12 gets refreshed ever month. Example : For this month data starts from Jan 2023 to June 2023 For next month data starts from Feb 2023 to july 2023 Here Column 7 starts from jan 2023, Column 8 starts from Feb 2023, Column 9 start from mar 2023,,, Column with jun 2023 For next month Column 7 start with Feb 2023, Column 8 start with Mar 2023,,, Column 12 with July 2023 The requirement is 1) All the Column present in the data set should be placed in TABLE Visualization only. Problem : 1) when ever the Current month data is added to table Visualization ie., jan 2023 to Jun 2023 the visual looks fine. 2) as data gets refreshed next month (next month data start from. Feb 2023 to July 2023) Table visualization has only Feb, mar, Apr, may, jun. Where in July 2023 is not added to table visual as the Column name got changed hence my visual Breakdown. Need Help •Can we achieve this by index •Can we achieve this by dax with column7 is replaced by Apr 2023 •can we achieve this by power query dynamically • is there any way to achieve this.
