Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gerasimovav
Helper III
Helper III

KPI visual shows last month figure

Hello, colleagues!

I have the KPI wich is year percent.

For example:

fig1.png

 

I want to create KPI with dynamics in background.

According tour, I created the terget measure (40%), then created the diagram:

fig2.png

Then press on "KPI" visual, and got:

fig3.png

 

Background is perfect, but figure is for last month only (December). I need full year digit.

I'm looking forward to find solution.

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi,

Use KPI Indicator instead of the KPI.

May be problem can be solved by using the date field in the visual level filter and selecting the relative date filtering and selecting last 1 year data range. Put aggregation type as sum in field tab.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi,

Use KPI Indicator instead of the KPI.

May be problem can be solved by using the date field in the visual level filter and selecting the relative date filtering and selecting last 1 year data range. Put aggregation type as sum in field tab.

@Anonymous thank you!

 

Omega
Impactful Individual
Impactful Individual

Try using KPI Indicator visual. This is a custom visual that you can download from the marketplace. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.