Forum Discussion
How to implement Data over 24 Hours & Line Chart
- Anonymous1 year ago
Hi All
Firstly lbendlin thank you for your solution!
And Anonymous,If you want to realize in a visual object, two different groups of filters on the filter of the filter, is currently not feasible, there is a group to choose 15, a group to choose 16 when there will be a conflict phenomenon, which will show a blank value, the solution to this problem is to write the value of the measure of the Day fixed, can not be changed dynamically, only a group of filters can be accomplished for the side of day 1 and The solution to this problem is to fix the value of Day when writing the measure, which cannot be changed dynamically. Limitations are also more obvious can not dynamically select the date.Day 1(FIX) = VAR A=SELECTEDVALUE('Date Table'[DAY],MAX('Date Table'[DAY])) RETURN CALCULATE(MAX('Sample_Data (2)'[value]),FILTER(('Sample_Data (2)'),'Sample_Data (2)'[Hour]<=MAX('Date Table'[Hour])&&'Sample_Data (2)'[DAY]="15"))Day 2 (FIX) = CALCULATE(SUM('Sample_Data (2)'[value]),FILTER('Sample_Data (2)','Sample_Data (2)'[Hour]<=MAX('Sample_Data (2)'[Hour])&&'Sample_Data (2)'[DAY]="16"))
I'm trying to use the second approach but this requires two visual objects to back it up, day 1 and day 2 independent of each other at the same time, controlled by two sets of filters for comparison and allowing for dynamic filtering of days.
I hope my alternatives are helpful, and you can check out my pbix file if you still have questions!Hope it helps!
Best regards,
Community Support Team_ Tom ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi All
Firstly lbendlin thank you for your solution!
And Anonymous,If you want to realize in a visual object, two different groups of filters on the filter of the filter, is currently not feasible, there is a group to choose 15, a group to choose 16 when there will be a conflict phenomenon, which will show a blank value, the solution to this problem is to write the value of the measure of the Day fixed, can not be changed dynamically, only a group of filters can be accomplished for the side of day 1 and The solution to this problem is to fix the value of Day when writing the measure, which cannot be changed dynamically. Limitations are also more obvious can not dynamically select the date.
Day 1(FIX) =
VAR A=SELECTEDVALUE('Date Table'[DAY],MAX('Date Table'[DAY]))
RETURN
CALCULATE(MAX('Sample_Data (2)'[value]),FILTER(('Sample_Data (2)'),'Sample_Data (2)'[Hour]<=MAX('Date Table'[Hour])&&'Sample_Data (2)'[DAY]="15"))Day 2 (FIX) = CALCULATE(SUM('Sample_Data (2)'[value]),FILTER('Sample_Data (2)','Sample_Data (2)'[Hour]<=MAX('Sample_Data (2)'[Hour])&&'Sample_Data (2)'[DAY]="16"))
I'm trying to use the second approach but this requires two visual objects to back it up, day 1 and day 2 independent of each other at the same time, controlled by two sets of filters for comparison and allowing for dynamic filtering of days.
I hope my alternatives are helpful, and you can check out my pbix file if you still have questions!
Hope it helps!
Best regards,
Community Support Team_ Tom Shen
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.