months with dynamic axis
I need to create a physical table in Power BI containing the last 12 months prior to the month that is being filtered in the data segmentation and at the end of this table I need to have an average so that I can use it as the X axis of a graph. How can I achieve this? My goal is to place the months on the X axis of the graph so that it shows the last 12 months in the format "MM/YYYY" and the average. See below the expected result: The example below illustrates that the month '03/2025' is being filtered in the data segmentation, so the table is returning the last 12 months prior to '03/2025'. I have a table (dCalendar) of dates that is related to other tables
Referencing multiple columns with 2 tables
I have columns: ID, Assigned to Primary, Assigned to Secondary, Assigned to Third, Assigned to Fourth, Assigned to Fifth, Assigned to Sixth, Assigned to Seventh. Primary Estimated Hours, Secondary Estimated hours, Third Estimated hours, Fourth Estimated Hours, Fifth Estimated Hours, Sixth Estimated Hours, and Seventh Estimated hours. Primary Estimated hours is associated with Assigned to Primary Secondary Estimated hours is associated with Assigned to Secondary Third Estimated hours is associated with Assigned to Third Fourth Estimated hours is associated with Assigned to Fourth Fifth Estimated hours is associated with Assigned to Fifth Sixth Estimated hours is associated with Assigned to Sixth Seventh Estimated hours is associated with Assigned to Seventh Each Assigned to position has a different employee assigned to with different estimated hours. Each Record (ID) can have up to 7 assignees with different names and estimated hours How could I write a statement that looks at each record and calls out the record, the position, Employee name, and which estimated hours field is 0? Essentially I would like to look at folks who are assigned to a record but have not input any estimated hours. Thank you very much for your time
Visualising Two Non Numeric Columns
Hello , I have three fields Date,Name and Percentage.To show it in a visual. I want to group [Names] with [Percentage] column or [Date] with [Percentage] with the help of DAX . Since there are so many items in Names column and also there are two non numeric columns. That way I dont have to use Names or Date column in the visual as two Non numeric columns cant be used. I dont want to use Legends and Slicers bcoz there are too many Items in Name columns. It would be difficult for analysis. The Left Side side I need in visual.Please help. Please tell if I am thinking correctly.Matrix Table with multiple layers breakdown
Hello guys, I have a question that is challenging me and I am struggling to find the write way to visualize it in a matrix table. I have a table as below and I want to create a matrix table where It will show me the headers as the first row and then the breakdown will be Project name, WBSE code, contract number however The key question is how would I make the project name row shows the key numbers and then the wbse row shows only the values set to it without repeating the values above and similarily the contract number values while wbse and contract values will sum to the initial project name row values. Is that possible? Project Name XYZ Location ERP Number Money Allocated Money Spent Money Saved Actuals Total Budget New Total New Budget Department 2 Contract price Project 1 Calgary ZH-000123 $ 50,000 $ 750,000 $ 25,000 $ 5,000 $ 830,000 $ 792,500 $ 150,000 $ 280,000 $ 10,000 Pro - 1 - WBSE $ 25,000 $ - $ 25,000 $ 5,000 $ 55,000 $ 42,500 $ 25,000 $ 30,000 $ 10,000 Contract 1 $ - Contract 2 $ 10,000 Pro 2 - WBSE 2 $ 25,000 $ 750,000 $ - $ - $ 775,000 $ 750,000 $ 125,000 $ 250,000 $ - Contract 3 $ -Trouble Displaying Two Overlapping Line Graphs in Power BI using Dax functions
Hello Power BI community, I recently ran into an issue where I was trying to display two line graphs on top of one another in Power BI, but instead, they were being displayed as a single continuous graph line. The two functions that I was using were: AAAM_Prior_R12M = CALCULATE([Sum_Two_Rows], DATESINPERIOD('Calendrier'[Date],ENDOFMONTH(dateadd('Appointments Manager'[Period date],-12,month)),-12,MONTH)) AAAM_Current_R12M = CALCULATE(([Sum_Two_Rows]), DATESINPERIOD('Calendrier'[Date], ENDOFMONTH('Appointments Manager'[Period date]), -12, MONTH)) The Period date is a date column of the table Appointments manager. I appreciate your assistance.How to sort months by name on rolling 12 months using DAX measures
Hello Power BI Community, I am facing an issue with the x-axis on my line chart in Power BI. Specifically, when I apply the "PeriodCal" dax measure, the months for 2023 are shown on the left side of the line chart, while the months of the year 2022 are shown on the right side of the line chart in no specific order. I want to reverse the order so that the months for 2022 are shown on the left side and the months for 2023 are shown on the right side. I also attempted to sort the x-axis by "Current 12 months rolling" and "Prior 12 months rolling" (and by PeriodCal also) but to no avail. My objective is to sort the months from left (oldest month) to right (newest month) in a rolling 12 months format (March 2022, April ... December 2022, .... Jan 2023... March 2023) Here is the code I attempted so far for the "PeriodCal" measure I am using: PeriodCal = VAR __maxDate = MAX(Calendrier[Date]) VAR __minDate = MIN(Calendrier[Date]) RETURN SWITCH( TRUE(), Calendrier[Date] = __maxDate, "Current Month", Calendrier[Date] = __minDate, "Oldest Month", FORMAT(Calendrier[Date], "mmm yyyy") ) The following are my two measures applied to the graph to calculate the prior and current 12 months rolling : Prior rolling 12 months = CALCULATE([DAX_Measure_Sales], DATESINPERIOD('Calendrier'[Date],ENDOFMONTH(dateadd(Data[MyDate],-12,month)),-12,MONTH)) Current rolling 12 months = CALCULATE([DAX_Measure_Sales], DATESINPERIOD('Calendrier'[Date], ENDOFMONTH(Data[MyDate]), -12, MONTH)) I would greatly appreciate any help or suggestions on how to fix this issue. Thank you!Need help for a Visualization and Associated Data Modelling
Hi all, I am currently working on a time series data with the following structure: Timestamp - ID - EVENT-TYPE EVENT-TYPE is a column used to track entries and exits and is mapped to a column with +1/-1 as values, with +1 for entry and -1 for exit. Timestamps are Hourly, Non-Unique and Irregular (There can be multiple entries and exits in an hour, and no timestamps for time periods with zero footfall, usually on weekends and during night time) I am currently using a cumulative sum measure on this EVENT-TYPE column to visualize the total occupancy at any given time,and it's working fine. But I also want to allow my users to select any subset of the ID's and shift their in/out times by a certain amount and then see what impact it has on the overall occupancy. I am at my wit's end on how to figure this out, especially as I am not that experienced with the whole DAX/M/PowerBI ecosystem and am really struggling on how to do this. I would really appreciate if someone could show me how to do this in PowerBI. Please also let me know If I have missed any crucial details, or If I am asking this in the wrong section.Need help for a visualization and associated data model
Hi all, I am currently working on a time series data with the following structure: Timestamp - ID - EVENT-TYPE EVENT-TYPE is a column used to track entries and exits and is mapped to a column with +1/-1 as values, with +1 for entry and -1 for exit. Timestamps are Hourly, Non-Unique and Irregular (There can be multiple entries and exits in an hour, and no timestamps for time periods with zero footfall, usually on weekends and during night time) I am currently using a cumulative sum measure on this EVENT-TYPE column to visualize the total occupancy at any given time,and it's working fine. But I also want to allow my users to select any subset of the ID's and shift their in/out times by a certain amount and then see what impact it has on the overall occupancy. I am at my wit's end on how to figure this out, especially as I am not that experienced with the whole DAX/M/PowerBI ecosystem and am really struggling on how to do this. I would really appreciate if someone could show me how to do this in PowerBI. Please also let me know If I have missed any crucial details, or If I am asking this in the wrong section.
