cumulative measure in line chart
Hi everybody, I'm stuck with an issue that is bothering me for quite some time now. The orange line in the line chart below represents the cumulative written hours n a project. The hours are registered untill july, after that there is no data. As you see, the line continous untill the end of the year. I want to create a dax measure (or another solution if that's easier), that cuts off the orange line after the the point to which there is no more data available. Currently I use this measure: Cumulative_Geschreven Uren = CALCULATE(SUM('Urenregistratie'[Geschreven uren]), FILTER(ALLSELECTED( DateTable), DateTable[Date] <= MAX( DateTable[Date]))) ChatGPT recommened me this measure, but in this case the line cuts off in June, while there is data from the month July (see picture below). In this case i used the following DAX. Cumulative_Geschreven Uren (Cutoff) = VAR CurrentDate = MAX(DateTable[Date]) VAR LastDateWithData = CALCULATE( MAX(DateTable[Date]), FILTER( ALLSELECTED(DateTable), CALCULATE(SUM('Urenregistratie'[Geschreven uren])) <> 0 ) ) RETURN IF( CurrentDate <= LastDateWithData, CALCULATE( SUM('Urenregistratie'[Geschreven uren]), FILTER( ALLSELECTED(DateTable), DateTable[Date] <= CurrentDate ) ) ) Any solution would be greatly appreciated! Willem
Line dissappeared on a Line Chart when published to report server
Hello guys, I have 3 measures I added on a line chart in Power BI report server desktop. Anytime i published, all the line will display but after some minutes the black line (available cash) will disappear. This is on Power BI Report Server Desktop so after some minutes publishing this is how it will look What could have been the cause? Anyone experienced this before? Thanks for the help
How to add coloured shade area segments in a Line chart
Hi, I have created a Bell Curve line chart and plotted a point (read score point) on the line (see picture below). What i would like to add is 2 segments, 1 segment for the left side of the red point and 1 segment on the right side and colour them. In order to achieve this i have added a dax calculated column (with the text low and high) in the table. Is this possible in a line graph ? ps: I tried a "line and stacked column chart", see second picture. Now when i changed the entry from the Column y-axis to Line Y-axis i get this, see last picture. Thank you for advisingReplacing blanks with previous count in continuous line chart
Hi All I'm hoping someone will be able to help me modify this measure. I've tried a number of ways to make it work but can't quite seem to get it right. Where there is a blank week (Wk 9 in this example, I would like the figure from the previous week, e.g. 100 (Wk 8), so that my line is continuous and doesn't drop to 0. My measure so far is: 2024_cate_tickets = COUNTROWS ( FILTER ( ALL ( 'cate' ), 'cate'[week_num] <= MAX ( 'cate'[week_num] ) && 'cate'[date_registered] <= MAX ( 'cate'[date_registered] ) && 'cate'[event] = "cate 2024" ) )
Have a Line Chart Ignore Parameter Selected
Hello, I am trying to achieve having a line chart that shows the average revenue of the company selected. My only issue is that the two parameters that I have on the top of the report are DATE & COMPANY. Now I want the entire page to load off of the DATE & COMPANY selected, but for the line chart. I want this to just be affected by the COMPANY selected but show all data for all dates. Basically I am attempting to see the average of the revenue over time in this line chart, while having the rest of the report be filtered to the selected date parameter. Any help on this would be greatly appreciated.Line chart from Excel always shows flat line / bar for one table, summing up all values
Hi, Apologies if this has been covered before, I read many posts, but none had quite the same scenario. Using Power BI Online, I want to compare download numbers for an app, as well as a comparison of won / lost users, so a (stacked) line chart seems best. The data will always be for the constant stream of date and then varying values per OS. My data comes from an Excel, I have tried data (date in column a, numbers in column B) in one worksheet or distributed over two worksheets, the problem remains the same. The first set of values is displayed as desired, a zig-zag line on the Y axis depending on the value for a date on the X axis. However, the second set of values always sums up all values for the available dates, creating a flat line (or bar in a bar chart). Why is this happening? A stacked area chart with the exact same data works, I don't get it -.- Any help is appreciated - this seems fairly straightforward, although it's my first attempt with Power BI. Thanks!Line Chart Not Filtering Correctly! Help!
Hi, I need some help. My line chart is not filtering when I click on a filter. Please see example below: Although one school is selected and one filter (A level) on the line chart all data is shown. The relationship is below and is active; I just want the line chart to show the filtered line, any help would be greatly appreciated! ThanksAdding an overlay with a hyperlink to a line chart
I work on a data engineering team, and we have a PowerBI report that includes a line chart showing how long it takes for data to be processed. Spikes in this graph are typically related to an incident (configured in our incident management platform) that captures outages and disruptions to our service. I would like to display those incidents over this line chart (shown as red dots on the graph below). Each dot would represent an incident or group of incidents that fired at a particular time stamp. When I hover over or click on a red dot, I would like to see a tooltip or dialogue panel with more information about the incident(s) including incident number and a hyperlink to the particular incident on our incident management platform. Assuming the underlying data model is working and we are able to correlate incidents pulled from our incident management platform with the data from the line chart, what kind of visuals could I use to create these dynamic overlaid lables with hyperlinks? If there are no existing visuals that would allow this, has anyone tried any plug-ins or custom solutions that they could share? I would appreciate any help 🙂 cc: jayendrans
Projecting from known starting and ending values
Dear Power BI Community, I have the table below where I need to show for each site the emissions decreasing until it hit 0 by the "Net Zero Goal" column year within the duration indicated in the far right column. If the start year is 2023, all site except for E will hit 0 before its target year. Site Current Emissions Value Net Zero Goal Project ed Savings Duration A 835.75 2030 5 B 667 2050 25 C 932 2050 25 D 932 2050 25 E 504 2045 25 F 958 2050 25 G 1020 2050 25 H 771 2050 25 I 771 2050 25 J 1382 2050 25 K 1500 2050 25 I am having difficulty with creating a table that PBI can understand. I created the table below in excel and that worked but I'd like to be able to create this within PBI as the starting/current year could change depending on when the client wants to start their emissions savings. I created the table below for each site and appended them into one table and that worked. Like I previous stated, doing this in excel doesn't allow for me to adjust the starting year. Time Emissions Site ID 2023 835.75 A 2028 238.7857 A 2025.5 537.2679 A 2030 0 A I have tried to convert everything to dates using the following formalas datedif (excel), datediff (PBI) edate However, I ran into the following issues: Could not format a working table that PBI can make into a line chart I could not create a numeric range parameter for the projected start date One thing to note is that the project start date should align with the current emissions column from the first column. Such that if site A were to start in 2027, they would have 3 years to complete their emissions savings to reach the 2030 year target. The idea is to have several line charts that depict the emissions decreases for each site and being able to adjust the start year like below. Thanks in advance. Let me know if I can clarify something else!
