Power Platform Community Forum Thread Details

Background:

I have built a Powerapp that uses dashboard alerts to provide custom notifications on Dashboard values. It extends and enhances the existing notifications of Dashboard alerts. I can provide more derails if you are curious.

Goal:

I wish to enhance my app to provide trend analysis: are you likely to meet your goal or not. Or, just provide alerts when things are going sideways. An example could be Sales. You have a yearly sales goal, data is reported weekly in a line chart or bar chart, so you look at the totality of the data each week and project out the sales to the end of the year. The notification would be you are on track or you are not, or some custom evaluation dictated by the user. Alternatively, it could simply watch the sales data and notify you when there is a precipitous drop week over week.

This presents two challenges...

1. The math of projecting and/or defining thresholds in a manner that a user understands them. This part I have handled.

2. Accessing the underlying data in order for the calculations to be done. This I have no clue about.

We know that an alert only works for single number metrics: KPI, Card, Gauge. So I will need to go get the data behind the chart visual and here is where I need direction and suggestions:

QUESTION:

Given a Power Bi visual of a Line/Bar chart that has Dates on the horizontal axis and Sales numbers on the Vertical axis, how can my Power Bi App connect to this Power BI report/visual, and pull the data driving the chart? (Date/Sales, Date/Sales, Date/Sales, etc.)

Could this could be some kind of DAX/PowerM query, could be some other method I am unaware of, or will I have to simply query the data source directly (Definitely not preferred).

Thank You.

Categories:

Building Power Apps