Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
IF
Post Prodigy
Post Prodigy

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.

25.jpg

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!

 

1 ACCEPTED SOLUTION
v-kkf-msft
Community Support
Community Support

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 )
)

vkkfmsft_0-1633411685137.png  vkkfmsft_1-1633411716323.png

 

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.

 

 

View solution in original post

2 REPLIES 2
v-kkf-msft
Community Support
Community Support

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 )
)

vkkfmsft_0-1633411685137.png  vkkfmsft_1-1633411716323.png

 

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
Super User
Super User

@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

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.