Forum Discussion
Help needed regarding Power BI Metrics - Pulling Historical Data
Hello all,
I'm trying to pull in historical data in my scorecard / metric by making a connection to a visual as shown in the picture below.
Power BI Scorecard
The visual I want to connect to:
The visual above is about the percentage of the hours the employer was in a meeting.
The measure for this is as follows: [Total hours in meeting]/[Total registered hours]
When I connect the metric to the visual, it doesn't pull in the historical data.
When I change the input of the visual from Month to Date (Datum), I can pull the historical data.
But this way I don't have the desired visual I want to use. (See picture below)
This visual shows the measure on daily basis.
I need to have this on a monthly basis.
Is there a way to pull in the data per month into Power BI Metrics?
Is there a way to adjust the measure in such way, it shows [Total hours in meeting]/[Total registered hours] only at the end of each month?
With kind regards,
LazzaNova
2 Replies
Hi Anonymous ,
According to your description, what you need to do to use the Power BI Activity Log is to download the log and store it on your own storage to keep a record of historical data over a period of time.
Here are more details on what the Activity Log is and how to download it.Track user activities in Power BI - Power BI | Microsoft Docs
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
