cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kamaizziati Member
Member

How to filter the value data on card

Hi,

 

I want to show the data on CARD custom visual but I dont want its show the sum value of data if not select specific data using slicer.

 

Below is the data for column 1 and column2 

2017-11-09_1443.png

I want on the card custom visual show the data overall 10.17% not the sum of the column 2 data but at the same time it interactive with the the slicer custom visual.

 

 

Example:

1. Card shows data when not click the slicer

2017-11-09_1433.png

2. When I click WPC05 on slicer it will show data for WPC05

2017-11-09_1449.png

15 REPLIES 15
BeemsC Member
Member

Re: How to filter the value data on card

Hey,

If i understand correctly, you want to stop 1 visual interacting with another one.
This can be aquired by using 'edit interactions', in the Format tab

vrobeeld 2.png

Kamaizziati Member
Member

Re: How to filter the value data on card

Hi @BeemsC,

 

Thanks for your help but I dont want to stop the interaction. I want its interact with the slicer but I dont want the card custom visual show the sum of the data when we dont use the slicer. I want its show one of the data 10.17%. I think its will have DAX statement but I did not get it.

 

vik0810 Member
Member

Re: How to filter the value data on card

HI @Kamaizziati, where does 10,17% come from?

 

Generally you can use functions HASONEVALUE and VALUES for your measure, something like that:

 

Measure = IF(HASONEVALUE(Table[WPC]), VALUES(Table[Percentage]), [source for 10.17%])

 If 10.17% is constant value then

 

Measure = IF(HASONEVALUE(Table[WPC]), VALUES(Table[Percentage]), 0.1017)
Kamaizziati Member
Member

Re: How to filter the value data on card

Hi @vik0810,

 

10.17% is the one of data column 2. How I want to call below in my statement.

 

[source for 10.17%]

 

vik0810 Member
Member

Re: How to filter the value data on card

Why this row? is it the smallest/largest percentage? Or any other feature?

Kamaizziati Member
Member

Re: How to filter the value data on card

Hi @vik0810,

 

Because it is the overall percentage in the data. Not the smallest and largest percentage.  Its just the percentage number need to highlight.

 

 

Microsoft v-huizhn-msft
Microsoft

Re: How to filter the value data on card

Hi @Kamaizziati,

Based on my understanding, the column2 is a calculated column in your resouce table, right? If it is, please create a measure using the same formula as the one used in calculated column. And add the measure in card visual.

Best Regards,
Angelia

Kamaizziati Member
Member

Re: How to filter the value data on card

Hi @v-huizhn-msft,

 

Not, the calculation not based on the data

Microsoft v-huizhn-msft
Microsoft

Re: How to filter the value data on card

Hi @Kamaizziati,

The screenshot including column1 and column2 is a table visual? Please share your sample table, you can post same data model with fake data, and list the expected the result. So that we can analyse your problem deeply.

Best Regards,
Angelia

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,494)