cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LaZZaNoVa-61
Helper II
Helper II

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
LaZZaNoVa61_0-1663071437376.png

The visual I want to connect to:

LaZZaNoVa61_1-1663071485221.png


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)

LaZZaNoVa61_2-1663071744725.pngLaZZaNoVa61_3-1663071778193.png

 

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 2
LaZZaNoVa-61
Helper II
Helper II

No not the answer I was looking for. Perhaps I should describe my problem more accurately.

v-henryk-mstf
Community Support
Community Support

Hi @LaZZaNoVa-61 ,

 

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.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.