Forum Discussion

IF's avatar
IF
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Dynamic card values in the same page

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:

TYPECategoryValue1Value2MMYYYYDate
AM1121101.20191/1/2019
AM11211.201911/1/2019
AM1232103.20193/1/2019
AM2111001.20191/1/2019
AM21111.201911/1/2019
AM2222203.20193/1/2019
BM1222101.20191/1/2019
BM13211.201911/1/2019
BM1242503.20193/1/2019
BM3111101.20191/1/2019
BM32211.201911/1/2019
BM3222403.20193/1/2019
CM4151501.20191/1/2019
CM44311.201911/1/2019
CM4232503.20193/1/2019
CM3121101.20191/1/2019
CM33211.201911/1/2019
CM3222003.20193/1/2019

 

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

MMYYYYDate
01.20191/1/2019
11.201911/1/2019
03.20193/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!

 

Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    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.

     

     

2 Replies

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.