Extract the Anomaly Detection Data after use SR-CNN in power BI

Question

Hello guys,

My case is that I use SR-CNN to scan my dataset, and I want to get the list of anomaly points along with its description (as in blue box in the image) in table form.

I look around but I have not seen any possible way.

Does anyone have the solution?

Answer 1

Hello @GodwinD-4582

Thanks for reaching out to us. Based on the document of Power BI, to extract the anomaly detection data after using SR-CNN in Power BI, you can follow the steps below:

After running SR-CNN on your dataset, you should have a table with the anomaly scores for each data point.

In Power BI, you can use the "Edit Queries" feature to transform the table and extract the anomaly points.

Open the table in the Power Query Editor and add a new column that identifies the anomaly points. You can do this by setting a threshold for the anomaly scores and flagging any data points that exceed the threshold.

Once you have identified the anomaly points, you can create a new table that only includes the anomaly points and their descriptions.

To create the description for each anomaly point, you can use the "Add Column" feature in the Power Query Editor and write a formula that concatenates the relevant information from your dataset.

Finally, you can load the new table into Power BI and use it to visualize the anomaly points.

I hope this helps! Let me know if you have any further questions.

Regards,

Yutong

-Please kindly accept the answer if you feel helpful to support the community, thanks a lot.