Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
No not the answer I was looking for. Perhaps I should describe my problem more accurately.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
7 | |
4 | |
3 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
5 | |
2 |