cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vjnvinod
Post Prodigy
Post Prodigy

card only shows first or last value

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)

 

shapes fading.JPG

1 ACCEPTED SOLUTION
SivaMani
Memorable Member
Memorable Member

 @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

View solution in original post

3 REPLIES 3
SivaMani
Memorable Member
Memorable Member

 @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

@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

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors