Agenda:
- Problem Statements.
- Solution.
1. Problem Statement:
We need one card that will show some text and selected values from the slicer.
e.g., I have one slicer (i.e., year) and I want to display “Year is: 2022” depending on the slicer.
2. Solution:
Take one slicer, “Year.”
For the dynamic card, we need to create one measure.
Here is the DAX Expression:
Selected_val =
VAR Cond =
IF (
HASONEVALUE ( ‘Date Table'[Year] ),
SELECTEDVALUE ( ‘Date Table'[Year] ),
“”
)
RETURN
CONCATENATE ( “Year is : “, Cond )
Here, we are concatenating the text “” with a variable.
Take a new Card Visual and drag & drop this measure into the Card Visual.
Result:
Conclusion: We can display a dynamic selected value from the slicer with a static value in Card Visual
Rubika Jadhav
Data Analyst
Addend Analytics
Author By
Afroz Labbai
Afroz is a Data Engineer and Team Lead with 4+ years of experience in building scalable data platforms using Azure technologies such as Azure Data Factory, Azure SQL, Databricks, and Synapse. He specialises in ETL development, SQL optimisation, and data modelling, delivering reliable and cost-efficient solutions for enterprise analytics. He is passionate about continuous learning, mentoring teams, and driving data-driven decision-making.
