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
Replacing 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" ) )
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! Thanks
Deneb Line Chart using "repeat"
Hi everyone, I am trying to make a multiple views line chart in @deneb. Its a replication of what Power BI guy made in this video.(link attached at the end). My line chart however, has two scenarios: Act and Bud. I was able to get those. However, I want budget line to be a dotted line and I am not able to get it. Could you please help with it? Power BI file and Code attached below: What I can do so far: Power BI link: https://drive.google.com/file/d/1Eghfv1IYX4zzcsIvXT7emUrHbN41EaWN/view?usp=sharing Deneb Code: { "title": { "anchor": "middle", "align": "center", "offset": 10, "text": "Ratio Analysis", "font": "Segoe UI", "fontSize": 16, "fontWeight": "bold", "fontStyle": "normal", "subtitle": "Monthly Comparision", "subtitleFontSize": 12, "subtitleFontStyle": "italic" }, "data": {"name": "dataset"}, "repeat": [ "Bonus T", "Pts Rolling T", "Total Pts by GW T" ], "columns": 1, "spec": { "mark": "trail", "encoding": { "x": { "field": "Round", "type": "ordinal", "title": null }, "y": { "field": {"repeat": "repeat"}, "type": "quantitative", "formatType": "pbiFormat", "format": "#.00%" }, "color": { "field": "Scenario", "type": "nominal", "scale": { "range": ["black", "gray"] } }, "tooltip": [ { "field": "Round", "type": "ordinal" }, { "field": {"repeat": "repeat"}, "type": "quantitative", "formatType": "pbiFormat", "format": "#.00%" } ] } }, "resolve": { "scale": { "x": "independent", "size": "independent" } } } Power BI guy Youtube link: https://www.youtube.com/watch?v=I6FZYTSKI6Y&list=PL6oIJxyQvMGTxh4tREeKflcKVlOfGdyim&index=2
How to plot percentile wise values in Power BI?
Description: We want to plot percentile wise values in line chart in Power BI for larger set of data currently we have used below formula to calculate Percentile Rank Percentile = (No of value below Max Number/ Total No of values ) * 100 Issue: Not able to generate output for larger amount of data due to in sufficient memory. We need similar functionality like PERCENTRANK.INC formula of excel in Power BI. Chart Values: X-axis : Percentile values between 0 to 100 Y-axis: Actual value or Average value Let me know if any one has optimium approach for same use case. ThanksSorting/filter data by particular month in line chart
Hello all, I have a query about sorting data in a particular month in line chart. Line chart is showing a series of data, example as below. At the moment, my top 5 item groups are sorted by total value of item groups. What if at each month, I need to sort the data in descending order for that particular month, how do I do it in filter or DAX? It’s easy in excel by just sorting a particular column, but I don’t know how to do it in Power BI. As I’m sorting item group orders at each month, which means my top 5 item groups will be different as at each month.NO lines connecting point on line chart?
Hello, I have 3 measurements on the line chart. I would like them to be connected with line ? Any ideas why please ? There is date table with relationship to Table 1,2,3. All 3 have date column with dates in all rows as per screeshot. Total data points = DIVIDE(CALCULATE(COUNT('Table1'[Number])*112),DISTINCTCOUNT('Table1'[Attribute])) Total data points 07 = DIVIDE(CALCULATE(COUNT('Table2'[Number])*112),DISTINCTCOUNT('Table2'[Attribute])) Total data points 08= DIVIDE(CALCULATE(COUNT('Table3'[Number])*112),DISTINCTCOUNT('Table3'[Attribute]))Can't seem to create a line chart with date measure field
I am trying to create a line chart visual with status date on the X axis and status number on the Y axiz but can't use the measure index or date fields in the X axis. This is related to a process going through different stages with an estimated duration known for each stage. First I select the process type I am interested in. This gives me the duration at each stage. Then I convert the start date to a workday index with a LOOKUPVALUE on a date table so I can count only workdays. Start WorkDayIndex Col = CALCULATE(lookupvalue('Calendar2 (EDWn)'[WorkDayIndex],'Calendar2 (EDWn)'[Calendar Date],FIRSTDATE(MoldQual_RCGL[ProcessStart]))) Adding the Start WorkDay Index to the Completed Total duration, I get a Status WorkDayIndex measure. Status WorkDayIndex = [Start WorkDayIndex]+sum('Mold Qual Duration Categories'[Completed Total]) I then use the Status WorkDayIndex measure to Lookup a Date. ProjectedStatusDate = calculate(LOOKUPVALUE('Calendar2 (EDWn)'[Calendar Date],'Calendar2 (EDWn)'[WorkDayIndex],[Status WorkDayIndex])) This all works in a table but I can seem to use the ProjectedStatusDate in a line chart visual. I can't drop the field in the field box.Creating a visual based on measure returning a date
I am having trouble creating a line chart based on the filtered table below. It shows the Status (Stage) in production, how long it takes to get to that stage (Running Total), and a lookup to a calendar day for the completion of the stage. The Calendar table has an index of working days. I use the measure below to calculate the end date of different stages. ProjectedStatusDate = calculate(LOOKUPVALUE('Calendar (EDWn)'[Calendar Date],'Calendar (EDWn)'[WorkDayIndex],[Start WorkDayIndex]+[RunningTotalMeas])) I can put this in a table visualization... However I can't seem to get any sort of visualization to work that shows Status Num vs Projected Status Date. Power BI won't let me drop the Project Status Date measure in the X or Y axis fields. Thanks!
