need Urgent help - Display the monthly value

[Swamy3105]

Hi Experts,

I need realy urgent help.

I have the data with Actual and Plan with 2018 Whole year data, and 2019 with the current month (March) data.

I just calculated the max month, but it not working. because when i select the 2019 in the slicer it's working fine, because i have the data till march, but when i select the 2018, it's showing the Decemeber month's data, because in 2018 the max month is December. even if select the December month data it should show the March month data only.

How to do that, please help, I have a POC with my stakeholder tomorrow. I do not want to add the month slicer.

Please help......

[v-yuta-msft · Accepted solution]

@Swamy3105 ,

You may create a measure like pattern below and drag it to the card visual:

Result =
CALCULATE ( MAX ( Table[Date] ), ALL ( Table ) )

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Swamy3105 ,

I'm no experts, but if what you really need is just March, I believe there is a Visual Filter under the Fields section if you click on the visual. And you can specify it.