cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
marcelammelo Regular Visitor
Regular Visitor

Re: Dashboard tiles don't uptade on change of month

Hi, all!

 

I really tried to find a better solution, but, as Dale said, the "tiles are snapshots of special visuals in special status".  So, I just can do DAX measures and pin them to dashboard and it works fine. Although I wanted something easier like the dashboard "follows" my report filters, there are no options. "Pin live page" is not so useful to me.

 

Thanks for all support, Dale!

 

Best regards,

Marcela.

Benoit_L Frequent Visitor
Frequent Visitor

Re: Dashboard tiles don't uptade on change of month

Hello @marcelammelo

 

I am interested in your solution, how do you get a self-updating dashboard tile, each month, with a DAX measure ?

 

How does the DAX measure update automatically for each month ?

 

Thank you Smiley Happy

marcelammelo Regular Visitor
Regular Visitor

Re: Dashboard tiles don't uptade on change of month

Hi @Benoit_L!

 

You can do measures which you set a condition that gets the current month, for example. This will work if your main table be connected to date dimension or once you have a date in your main table.

 

Example:

 

Amount Collected In Current Month = CALCULATE(SUM(Billing[Amount]);YEAR(TODAY()) = YEAR(Billing[Date]) && MONTH(TODAY()) = MONTH(Billing[Date]))

Got it?

 

Best regards,

Marcela.

 

Highlighted
Benoit_L Frequent Visitor
Frequent Visitor

Re: Dashboard tiles don't uptade on change of month

Yes got it ! Using the TODAY() function to compare to my date

 

Thank you @marcelammelo