Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

How to implement Data over 24 Hours & Line Chart

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...
  • Anonymous's avatar
    Anonymous
    1 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 Shen

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.