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
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.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 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.
