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
Anonymous
Not applicable

KPI visual show YTD or multiple months

Hi,

 

I am hoping someone can help me return the YTD value (or multiple months) that are selected in a "Month" slicer to show up in the KPI visual?

 

Thanks

2 REPLIES 2
Anonymous
Not applicable

Can you please share more details? The above information is not giving full picture of the requirement.

 

Thanks

Raj

Anonymous
Not applicable

Hey Raj,

 

This is the data it is selecting:

 Power BI snapshot.PNG

And the resulting solution comes back as, which is just the latest month not the cumulative average:

Power BI snapshot1.PNG

 

So just selecting the last month, not the cumulative view. I think it might have something to do with the “Trend axis” that I am using? (here I am using a month column from the raw data)

 

Any help would be great. Thanks

 

 

 

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.