I want my table to show the numbers of the LAST MONTH only by default (when user opens the report)
But I want my users to be able to click on any bar on the upper chart so that the table shows the data FOR THAT SPECIFIC CHOSEN MONTH.
How do I achieve that efficiently?
Go to Solution.
You may try to create a measure like below:
VAR a =
"b", CALCULATE (
SUM ( 'Table'[Sales] ),
MONTH ( 'Table'[Date] ) = MONTH ( MAXX ( 'Table', 'Table'[Date] ) )
SUMX ( a, [b] )
View solution in original post
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!