Dynamic card values in the same page

[IF]

Hi,

I want to show card figures based on the slicer selections. I have slicer1 for month selection and slicer2 for the type selection. Based on the selection, the cards should show the category type, value1, and value2.

My example data is:

TYPE	Category	Value1	Value2	MMYYYY	Date
A	M1	12	11	01.2019	1/1/2019
A	M1	1	2	11.2019	11/1/2019
A	M1	23	21	03.2019	3/1/2019
A	M2	11	10	01.2019	1/1/2019
A	M2	1	1	11.2019	11/1/2019
A	M2	22	22	03.2019	3/1/2019
B	M1	22	21	01.2019	1/1/2019
B	M1	3	2	11.2019	11/1/2019
B	M1	24	25	03.2019	3/1/2019
B	M3	11	11	01.2019	1/1/2019
B	M3	2	2	11.2019	11/1/2019
B	M3	22	24	03.2019	3/1/2019
C	M4	15	15	01.2019	1/1/2019
C	M4	4	3	11.2019	11/1/2019
C	M4	23	25	03.2019	3/1/2019
C	M3	12	11	01.2019	1/1/2019
C	M3	3	2	11.2019	11/1/2019
C	M3	22	20	03.2019	3/1/2019

I have a month table and type table to use at the slicers:

MMYYYY	Date
01.2019	1/1/2019
11.2019	11/1/2019
03.2019	3/1/2019

TYPE

A

B

C

The link for the file is (in case of need):

https://www.dropbox.com/s/nn0n72iu5ggwc0a/Question%20dynamic%20card%20values.pbix?dl=0 

Thank you very much in advance!

[v-kkf-msft · Accepted solution]

Hi @IF ,

Please try the following measures:

ConcatenateValue = 
CONCATENATEX (
    'Data',
    SELECTEDVALUE ( Data[Category] ) & " " 
        & "Value1: " & SELECTEDVALUE ( Data[Value1] ) 
            & " Value2: " & SELECTEDVALUE ( Data[Value2] )
)

Measure = 
CONCATENATEX (
    ALLSELECTED ( Data[Category] ),
    [ConcatenateValue],
    UNICHAR ( 10 )
)

  

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

[amitchandak]

@IF , Not very clear. But one of these two should help

How Interactions Work- Split Page using interactions to compare: https://youtu.be/GIfRKzhMaR4

How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg