Show standard last value card visual and change by clicking

[BYENER]

Hi All,

I want to show standard the last value on the Card visual. When I click on another date in a bar visual than card value have to be changed.

Can someone help?

[BYENER]

thanks @Anonymous  this is working!

[Anonymous · Accepted solution]

Hi  @BYENER ,

Here are the steps you can follow：

1. Create measure.

Sum =
var _1 = MAXX(ALL('Date'),'Date'[Date])
return
IF(ISFILTERED('Date'[Date]),SUM(Group_registratie[Bruto Duration]),SUMX(FILTER(ALL(Group_registratie),[Date]=_1),[Bruto Duration]))

2. Result:

When selecting, display the current value:

When not selected, the final value is displayed:

Best Regards,

Liu Yang

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

[Anonymous]

Hi  @BYENER ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Best Regards,

Liu Yang

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

[BYENER]

Hi @Anonymous ,

https://www.dropbox.com/s/53i77va649f201n/TestPowerBI.pbix?dl=0 

[Anonymous]

Hi  @BYENER ,

I create some data:

Here are the steps you can follow：

1. Create measure.

Measure =
var _1=MAXX(ALL('Table'),'Table'[date])
return
IF(ISFILTERED('Table'[date])
,SUM('Table'[amount]),
SUMX(FILTER(ALL('Table'),'Table'[date]=_1),'Table'[amount])
)

2. Place the measure in the card

3. Result:

When not selected, the final value is displayed

Select a date and display the value of the date:

Best Regards,

Liu Yang

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

[BYENER]

@Anonymous  , I used the measure, but still the same. Did I something wrong in the measure?

var _1 = MAXX(ALL('Date'),'Date'[Date])

return

IF(ISFILTERED('Date'[Date])

,SUM(Group_registratie[Bruto Duration]),

SUMX(FILTER(ALL('Date'),'Date'[Date]=_1),SUM(Group_registratie[Bruto Duration])

))

[selimovd]

Hey @BYENER ,

you can disable that the selection of the bar chart will interact with the cards.

Check the documentation on how to do that:

Change how visuals interact in a report - Power BI | Microsoft Docs

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[BYENER]

@selimovd I don't want to disable it. It's showing the last date value, but when I click on anoter data than it shows BLANK. It should display the value instead of blank.

[selimovd]

Hey @BYENER ,

it's displaying the value.

But for your example the value on May 26th is blank, for that reason it shows blank. You can override this behavior with DAX, but then you have to define specifically what it should display.

You could say when it's blank it should show the total. But to be honest that will be very confusing for users as they never know if that's now the value of the current selection or if it's the total.

It's your choice at the end.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[BYENER]

@selimovd  Okay let's try to explain in another way. When I click on 26th of June than the values from that day are showing in the card visuals. When I don't click on any date than it shows the total value except the card on the top. That is displaying the last date. 

I want to show also on the other cards the last value when we don't click on the bars and when we click then the value of the selected date.

Below is showing the total values.

[selimovd]

@BYENER I know what you means. You solve that by a measure like that:

UrenVisual =
IF(
    [Uren] = BLANK(),
    CALCULATE(
        [Uren],
        ALL( myTable )
    ),
    [Uren]
)

But again, the user will not know if he sees the total or the selected date. So be prepared to answer some questions about wrong results or confusion. Or worse that people use the total for a date because they click the date and it shows the total instead of the actual result.  

Best regards

Denis