Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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. 

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

 

 

Need Help
Tips and Tricks

7 Replies

  • Cristian_Angyal's avatar
    Cristian_Angyal
    Most Valuable Professional
    6 years ago

    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 

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello,

       

      thanks for your quick response. 

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

       

      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