card visual - query

[pvenkat]

Is there any way I can get the displayed data on the card visual? 

My problem is I have two card visuals. I cannot use a multi row card as the two cards are acted upon by different slicers (some don't interact with one visual). So, though the underlying data is the same, the visuals show data based on different criteria and hence cannot be on the same visual. 

I am trying to get the % difference between the displayed data in the two cards. Any help is appreciated

-Prasad

[v-yuta-msft]

@pvenkat ,

Could you please share some sample data and clarify more details about your requirement?

Regards,

Jimmy Tao

[pvenkat]

Here is a test data set for what I am trying to build with:

Date	Route Time	Clean Time	Clean Time - Route Time	Inspection Time	Inspect - Clean Time	Vert Surfaces	Horiz Surfaces	Final Scores
3/16/2020	9:00	9:01	1	9:15	14	1	1	1.0
3/23/2020	9:00	9:05	5	11:16	131	4	5	4.7
3/30/2020	9:00	9:20	20	10:00	40	1	3	1.8
4/6/2020	9:00	8:50	9	11:16	146	4	5	4.7
4/13/2020	2:00	2:18	18	2:45	27	1	2	1.3
4/20/2020	2:00	2:40	40	4:20	100	3	5	4.0

[pvenkat]

[v-yuta-msft]

@pvenkat ,

You should disable Slicer3 in the first card visual and disable Slicer2 and Slicer3 in the second card visual. For details, please refer to doc below:

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

Community Support Team _ Jimmy Tao

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

[pvenkat]

Jimmy,

The edit interactive features of the slicers was already done. My challenge is to get the % of the data that is now shown in the card visuals. 

Regards,

Prasad

[v-yuta-msft]

@pvenkat ,

Could you share the dax expression of S1 and S2 so I could do further analysis?

Regards,

Jimmy Tao

[Greg_Deckler]

Just create a measure that does the same aggregation as the Card visual. So if the card visual sums 'Table'[Column],

Measure = SUM('Table'[Column])