How to implement Data over 24 Hours & Line Chart

[Rayudu1]

Hello Team,
Can you please help me with following issue.
I have the following table. I am trying to implement the output in 24 hours. The line chart axis should be 1-24 hours and values distributed accordingly only during the selected silcers Day1 (date, hour, minute, and AM/PM) and Day2 (date, hour, minute, and AM/PM) for the line chart.
Can you please find the sample data.

Slicers:-
Day1 Date:
Hour,Minute,AM/PM
Day2 Date:
Hour ,Minute,AM/PM
Line Chart:
X- axis:-24 hours
Y-axis:-Day1 value and Day2 value(2 Lines) .
is there any better way to show the values / hour.

Thank you. 

[v-xingshen-msft · Accepted solution]

Hi All
Firstly  lbendlin thank you for your solution!
And @Rayudu1,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.

[lbendlin]

Your requirement is unclear.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...