Card showing latest Period in a Range

[Anonymous]

Hi, Im trying to put a card that shows only the lastest period in a selected range from a Slicer. 

In the example, I wanna show just the value for Q2-2018 because is the latest period selected for the graph. 

[v-lili6-msft · Accepted solution]

hi, @Anonymous

After my test, you could use this way

Step1:

Add a Year Qtr Column

Year Qtr = YEAR('Date'[Date])*10+INT ( FORMAT ( 'Date'[Date], "q") ) 

Step2:

Drag this field into card visual level filter and set filter Top1

Result:

Best Regards,

Lin

[Anonymous]

Now I have a problem with a measure.... QoQ demand growth, 

Crec. Demanda Trim. =
VAR __PREV_QUARTER =
CALCULATE(
SUM('Demanda y Precios'[Demanda Mes (GWh)]);
DATEADD('Calendar'[Date];-4; QUARTER)
)
RETURN
DIVIDE(
SUM('Demanda y Precios'[Demanda Mes (GWh)]) - __PREV_QUARTER;
__PREV_QUARTER;0
)

If I use it in a card with the proposed Visual filter.... appears "blank" sometime, or "error"

[Anonymous]

Works fine.... thanks!!!

[chotu27]

@Anonymous 

Step 1 : Go to Visual Level Filter for Card

Step 2 :  And Drag Date column to Visual level filter of Card
Step 3 :  Select Relative Date Filtering and filter it as you wanted 

[Greg_Deckler]

No sample data so can't be super specific but use VAR to get the MAX of your [Date] and then FILTER down to that value within something like a MAXX or SUMX.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Thanks,

The time data are a monthly column in a table Calendar.[Date] with a relationship in the 'Demanda y Precios' table. It is used in the Hierarchy Slicer to select Quarters. 

The values that I wanna show in the card are 'Demanda y Precios'[PIB] (Quartely data), and 'Demanda y Precios'[Crec. Demanda Trim] (calculated column), both of them are shown in the table in the red circle in the image. 

I tryed:

Last PIB = CALCULATE(SUM('Demanda y Precios'[PIB]);Filter('Demanda y Precios';'Demanda y Precios'[Fecha]=MAX('Demanda y Precios'[Fecha])))

But [Last PIB] is blank.