card only shows first or last value

[vjnvinod]

Hi Community,

when i use Card for data visualization filter, it only shows the first or last field from the coloumn.

is there a way, we can show that as "All".

also when i click on charts or slicer my bar charts info gets faded, which apparently i don't wish to see it, how can we make sure that if i click any of the filters ,charts/bar graph shows as full(see below)

[SivaMani · Accepted solution]

 @vjnvinod,

Problem 1:

Create a measure like below and add it in the Card visual,

SelectedValue = SELECTEDVALUE(fieldname, BLANK())

Problem 2:

There is an option called Edit Interactions. With this option, you can control the interaction between visuals.

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

Thanks,

Siva

[vjnvinod]

@SivaMani

thanks for this, this helps,

Can you also help me with , i have a coloumn, with details account Name details

But there are some names which is completely in uppercase,  I Need change those upper case accounts to something like below

My current coloumn feld name: RAJESH RAM

Expected one: Rajesh Ram

[v-shex-msft]

Hi @vjnvinod,

You can try to combine use UPPER with FIRSTNONBLANK/LASTNONBLANK functions to get first/last non blank UPPER text.

Dax function reference:

FIRSTNONBLANK Function (DAX)

LASTNONBLANK Function (DAX)

UPPER Function (DAX)

Regards,

Xiaoxin Sheng