display data in card visual as per slicer selection in two different slicer dynamically

[amikm]

Hi all,

I am using one card visual to display some data that is coming from table1[PerformanceRatio]. I have the same column in other tables as well table2[PerformanceRatio] and table3[PerformanceRatio]. I want to have a single card visual that should show PerformanceRatio, but the value of this PerformanceRatio should change as per table selection.

[Tahreem24 · Accepted solution]

@amikm Try these steps:

Step 1: Suppose you have two table like Table 1 and Table 2 (As per screen shot attached)

Step 2: Create new Table from "Enter Data" and make structure like this:

Step 3: Then create a new measure under this table like below:

Measure =

VAR Selection_ = SELECTEDVALUE(TableName[TableName])

RETURN SWITCH(TRUE(),

Selection_ = "Table1",SUM(Table1[Ratio]),

Selection_ = "Table2",SUM(Table2[Ratio]),

SUM(Table1[Ratio])+SUM(Table2[Ratio]))

Step 3: Then take Slicer from New Table created and one card and this New Measure on this card.

Step 4: When you make any selection on that slicer it will reflect accordingly.

I hope I explained you well.

[amikm]

The value of [Performance ratio] is numeric (decimal data type)

[PhilipTreacy]

Hi @amikm 

You have 2 slicers?  For 3 tables?

What aggregation of [Performance ratio] is being shown in the card.

Please supply some more details, and maybe some screenshots of your current visuals.

regards

Phil