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

Displaying Multipile KPIs for current month

Hi all,

 

following situation. I build mutliple measures like yoy sales $ & % and mom $ & %.

Now i want to display them in the form of cards on my front page. 

This also works fine but i am not getting the value for the current month unless i select it. 

I want to see yoy growth from this month compared to last years month.

And the last years month in absolute numbers. 

My question is. 

How do i get the current month values for the yellow marked numbers. 

I mean the data is there and correct i just want to dsiplay it. 

image.png

I tried following measures:
 
gol = TOTALMTD([Invoiced sales];SalesInvoiceLines[InvoiceDate];FILTER(ALL(SalesInvoiceLines[InvoiceDate]);SalesInvoiceLines[InvoiceDate]<=MAX(SalesInvoiceLines[InvoiceDate])))
 
gol ly = CALCULATE([gol];SAMEPERIODLASTYEAR(SalesInvoiceLines[InvoiceDate].[Date]))
 
Thanks in advance.
 
BR,
Paul

 

 

7 REPLIES 7
amitchandak
Super User
Super User

You need to use current month filter on page or at visual level

Cristian_Angyal
Advocate III
Advocate III

Hello @Anonymous ,

 

I would try the following:

  • select the card you want to have the filter on
  • drag Date Field on the Visual Filter Pane
  • Select Relative Date on Filter Type
  • Set In this / Month and press Apply Filter

You have a picture below form a sample report 

Relative date filter.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

This should solve the filtering without additional DAX.

 

 

If you liked my solution please give it a thumbs up 👍

If I did answer your question please mark my post as a solution .

Thank you !

 

 

Cristian

Anonymous
Not applicable

Hello,

 

thanks for your quick response. 

I tried that but i am only getting following picture ... 😕image.png

 

That is the challenge that i am facing. My values are all there and if i filter via a slicer for this particular period i have the correct value but somehow i cannot filter on a visual level. 

 

 

BR,

Paul

What is your DAX Measure look like?
Anonymous
Not applicable

Invoiced Sales LY = CALCULATE(SalesInvoiceLines[Invoiced sales]; DATEADD(SalesInvoiceLines[InvoiceDate].[Date]; -1; YEAR))
 
Invoiced sales YoY % = DIVIDE([Invoiced sales];SalesInvoiceLines[Invoiced Sales LY])

You should try also a different formula:

Invoiced Sales LY = CALCULATE([Invoiced sales];SAMEPERIODLASTYEAR(SalesInvoiceLines[InvoiceDate].[Date]))

Hello @Anonymous ,

 

The Measures looks right.

Just built a sample Model to test the behaviour ... and it works ...

Visual Filter.png

 

I marked ny Calendar Table as a Date table ... maybe this is different ... or an additional filter ... or something related to the model

 

Cristian

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.