Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear community,
I'm struggling on setting up a filter to show only date between a calculated Minimum date and a Maximum date.
This dynamic filter must be applied on the line chart, means for each Job_No in the table has a different MIN Date and MAX Date.
Example for this particular job: this chart instead of being shown like this:
it should be shown like this:
The data comes from this table:
Many thanks!
Solved! Go to Solution.
Found a solution,
I've created new column in the table Progress(Sheet2) called P_Date.
hi @amitchandak ,
Many thanks for the reply. I think I did not explain enough what I'm looking to achive.
The two lines shown in the line chart are from two different tables.
I was able to connect and put the two graph together. but I wanted to limit the time windows by a maximum date and a minimum date taken from the first table (hours consumption)
so instead of showing 0 progress 3 or 4 months before the consumptions starts. I want to see the two graph from the moment I have hours consumption.
for that reason I've calculated the start date and end date of each project but I don't know how to apply this into the line chart.
Example of another project:
Not pleaseant view:
Desired automatic view:
Thanks for your help 🙂
My best regards,
Abdel.
Found a solution,
I've created new column in the table Progress(Sheet2) called P_Date.
HI @Abdel_BCN,
This sound like common multiple date fields analysis requirements, you can take a look at the following blog 'start date', 'end date' parts if it helps:
Regards,
Xiaoxin Sheng
@Abdel_BCN , not very clear. But you need measure like
new measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = minx(allselected(Date),Date[Date])
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] =_max)) - calculate( sum(Table[Value]), filter('Date', 'Date'[Date] =_min))
User | Count |
---|---|
56 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |