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
Addend Analytics is a Microsoft Gold Partner based in Mumbai, India, and a branch office in the U.S. Addend has successfully implemented 100+ Microsoft Power BI and Business Central projects for 100+ clients across sectors like Financial Services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Switzerland, and Australia. Get a free consultation now by emailing us at kamal.sharma@addendanalytics.com or Contact us.