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.
Design line graph with weekly subtotal from record with differential quantity
Dear All, I have a lot of records with the single quantity (eg. warehouse movements) and I would like to publish a line graphic with the total of each week (eg. weekly stock). My problem is that I only have the weekly movements and not the week stock. Example: Week 1 (begining) 100 Week 2 15 Week 3 -5 Week 4 7 Week 5 -20 Week 6 30 Week 7 8 Week 8 7 Week 9 -30 Week 10 -5 If I create a line graph with this data, I get something like below: This is not what I need beacuse on week 2 my stock was 115 (previous 100 + 15), on week 3 my stock was 110 (previous 115 - 5), on week 4 my stock was 117 (previus 110 + 7), ... I would like to get a graph like below: Could anyone give me a tip to obtain the second type of graph? How could I manage the data? Thank you FabioDAX measure - Stop the Line chart at current week for YTD Sales
Hello All You can see all last three YTD 2018, 2019, 2020 are plotted on the single graph to compare against 2021 YTD. The desired output that i like to achieve is to stop at current week the line graph. Attached PBIX and used DAX syntax https://drive.google.com/file/d/1KfQfWMP3eKebZoF7R2Xmz6Cce4RXsSKD/view?usp=sharing 1. SCE_Sales $ = SUMX(SCE,SCE[Sales $]) 2. SCE YTD $ = TOTALYTD([SCE_Sales $],'Date'[Date]) 3. View (All Year YTD) = VAR YearsBack = year(today()) - SELECTEDVALUE('Year'[Year]) RETURN CALCULATE([Electric YTD kWh], DATEADD('Date'[Date], -YearsBack, YEAR) ) Presently the current year YTD sales are only populated up to week 15 because weeks 16 – 52 have not happened yet (when the report was first build). From Week 16 2021 sales are showing flat-lining till week 52 which is misleading. How can I tweak the current DAX to stop (RED CIRCLED) from week 15 the 2021 YTD Black line? Would be very grateful if you can help me with modifying my current DAX or new DAX suggestion to stop at week 15 the 2021 YTD Blank line? Appreciate your help in advance. Many ThanksAdjusting use relationship formula to include specific measure values on line graph
I have 2 rolling 14 day average calculations and Im hoping to display them (highlighted) on the same line graph: However I've tried to create a userelationship measure to get them on to the correct axis and I'm getting the correct numbers for Epi Count but Event count values are coming in as counts rather than the ones I need (highlighted on left below): I'm using this measure: Cumulative Rate - Event Count = CALCULATE(COUNTX('Sheet1',[Prev 14 Day Event Count]/4761865*100000),USERELATIONSHIP(Sheet1[Event Date],DimDate[Dates]),NOT(ISBLANK('DimDate'[Dates]))) Can anyone help get the Cumulative rate -Event counts on to the line graph SEE FILE ATTACHED https://www.dropbox.com/s/ksi9fm0kbzpj1hg/Notification%20vs.%20Epi.pbix?dl=02 Measures on same line graph
I have 2 rolling 14 day average calculations and Im hoping to display them (highlighted) on the same line graph: However I've tried to create a date bridge and another table to relate to and still no luck with either approach. Where it should look more like this: Can anyone help with this? SEE FILE ATTACHED https://www.dropbox.com/s/ksi9fm0kbzpj1hg/Notification%20vs.%20Epi.pbix?dl=0
