Card Visual only showing First and Last Values for text values

[dosania]

Hi,

I am trying to create a report for my sales team to allow them to look at Customer performance and details.

I want to use the Card Visual to show details such as email address, city, email address etc, which updates based on the customer name selected.

When I add one of the vlaues from my database, which has around 500,000 unique customer IDs, on to the card visual, it only shows the First or Last value from the entire database, and not the value for the customer selected.

Is it possible to use the Card visual to show this information, or would something else be better suited?

I have tried using the following DAX to select the value I would like; SELECTEDVALUE(<columnName>[, <alternateResult>]), however this does not seem to work properly.

Any help would be much appreciated.

Thanks!

[amitchandak · Accepted solution]

@dosania , Create a measure like

Meausre =

if(isfiltered(Table[customer]),"email = " & Table[email] & "address = " & Table[address] & "city = " & Table[city] ,blank())

refer : https://www.youtube.com/watch?v=hXg3kRFSGjA

[PhilipTreacy]

Hi @dosania 

Download example PBIX with data and visuals shown below.

If you use a Table visual you can show customer details depending on what is selected e.g. in a Slicer.

With sample data like this

You can set up a table and a Slicer to display only the selected customer's details

and if nothing is selected then there's a measure that displays nothing in the table.  This measure is added as a filter on the table

Measure1 = CALCULATE ( IF ( ISFILTERED ( 'Customers'[CustomerName] ), 1, 0 ), ALLSELECTED ( Customers ) )

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[parry2k]

@dosania bast would be to create a measure if you select a customer, it should return the value otherwise blank, means if no customer is selected you don't see anything in the card or show some message like "select a customer"

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡