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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
inahury1
New Member

KPI card to display current month instead of December previous year

Struggling to get the KPI visual to display current month. Any help would be appreciated!

 

I have a measure for the previous monthly usage. 

Prior Monthly Usage = CALCULATE([Usage Days], PREVIOUSMONTH('Usage'[Started].[Date]))  

Then I have another measure to calculate the difference between the current month and previous.

Measure = DIVIDE([Usage Days], [Prior Monthly Usage], BLANK())-1

 

I want to display the Measure (difference) in the KPI visual but it doesn't want to display the current month. It displays December from the previous year. 

inahury1_0-1715365314864.png

 

Thank you!

 

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @inahury1 
Maybe you didn't filter the report / visual.

In this case, the engine default is the end of the current year .
I created an example to show how it works.
With slicer :

Ritaf1983_0-1715398846738.png

Without slicer/filter:

Ritaf1983_1-1715398903538.png

With filter by the "main" measure not blank :

Ritaf1983_2-1715399335765.png

The pbix is attached (the last 3 sheets are examples of what I showed)

 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

 

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

Hi @inahury1 
Maybe you didn't filter the report / visual.

In this case, the engine default is the end of the current year .
I created an example to show how it works.
With slicer :

Ritaf1983_0-1715398846738.png

Without slicer/filter:

Ritaf1983_1-1715398903538.png

With filter by the "main" measure not blank :

Ritaf1983_2-1715399335765.png

The pbix is attached (the last 3 sheets are examples of what I showed)

 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.