Forum Discussion

adarshmp8998's avatar
adarshmp8998
Frequent Visitor
2 years ago
Solved

Alarm Log Page

Hi @v-yohua-msft ,   This question is next to "Alarm Log, Start Time & End Time in Power BI Visual" which you have already answered.   Can you help me to get a single instance rather than all the...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • adarshmp8998's avatar
    adarshmp8998
    2 years ago

    Hi foodd , BeaBF , Anonymous,

     

    Please accept my sincere apology for not providing necessary/insufficent information.

    Please refer to the attached files and work is in progress for the same.

     

    Question:

     

    Lets consider a alarm of Low Temperature triggered at 11:01 and the it was active till 11:30 so between 11:01 to 11:30 Alarm Category will be Low Temperature. So here I want first row in the alarm log table that should be 11:01 as a start time instead of all records between 11:01 to 11:30.

     

    For Sample I am Creating a dummy Alarm Log Table to get visualize how alarm log table should look like.

     

    Please refer to the attached files of Sample Data set and pbi

    Sample Data:

    https://docs.google.com/spreadsheets/d/1675VjlLLT-3r_gx8JJY7be3KVX3hCFXl/edit?usp=sharing&ouid=110720534063898360565&rtpof=true&sd=true

     

    pbi File:

    https://drive.google.com/file/d/1tDY0ajaXCRlxt4LIzIL19HbV0RnxUg4S/view?usp=sharing

     

    Asset NameAlarm CategoryStart TimeEnd Time
    A Low Temperature09-07-2024 07:5909-07-2024 07:59
    A Low Temperature10-07-2024 08:5910-07-2024 09:05
    A High Temp11-07-2024 07:2911-07-2024 07:45
    BLow Temperature09-07-2024 07:5909-07-2024 09:59
    BLow Product10-07-2024 08:5910-07-2024 09:05
    BHigh pH11-07-2024 07:2911-07-2024 07:45
    CLow BOD09-07-2024 07:5909-07-2024 08:30
    COther 10-07-2024 08:5910-07-2024 09:05
    CLow BOD11-07-2024 07:2911-07-2024 07:45
foodd's avatar
foodd
Community Champion
2 years ago

Hello adarshmp8998 ,  thank you for sharing your question with the Community.   Remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

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

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

 

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!