Consume multiple selected slicer values in separate cards

[Anonymous]

I have a report which has multiple cards made to look like a table as below.

Entity	Particulars	Q1	Q2
ABC	Sales	122	1234
	Profit	1345	2143
DEF	Sales	189	108
	Profit	244	7890

I need to place a slicer on Entity in the report where the user can select 5 random entities and see their respective sales and profit. Is there any way I can pull the multiple selected values from the slicer and place it in indivdual cards - Selected Value 1 in Card 1. Selected Value 2 in Card 2 and so on.

Secondly, the whole table is built with multiple cards containing indivdual measures. Is there a better way to do this ? If yes please guide.

[richbenmintz]

Hi @Anonymous ,

Have you tried the Multi Row Card?

[Anonymous]

@richbenmintz , thank you for your prompt reply. Yes I have tried multi row cards. It suffices the display purpose . However I need to pass the value in the table to the DAX applied in columns Q1 and Q2 to filter the specific entity. 

[richbenmintz]

@Anonymous ,

Not sure I understand the requirement are you able to provide a sample file with data and the expected behavior

[Anonymous]

Please see the attached file for the raw data format and the expected output. Please note I would be placing a slicer on the entity to filter only the required entities.

Thank you,

Vinay

Sample File 

[richbenmintz]

Hi @Anonymous 

See Attached, 

created an additional column - Quarter in the dataset, best practice would be to create a date table and join to fact, then used a matrix with measures on rows to diplay the data.

sample pbix 

Hope this helps,