The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have two slicers : Year and Period. Year is a single selector slicer and Period is multiselector. A Text needs to be displayed in a card based on the slicer selection.
If an year is selected and all the period of that year are selcted then display "Selected Year is '2022' " ELSE
if any period is selected for eg 1, 3,5 then display "Selected Range is for "Year" and Period 1,3,5"
pbix file: https://drive.google.com/file/d/1owzvBBV1ALzdNukg5pgjUaPApTgYDPaD/view?usp=sharing
Solved! Go to Solution.
I have tweaked the below measure, if anybody is looking for the similar requirement then this measure can be used:
I have tweaked the below measure, if anybody is looking for the similar requirement then this measure can be used:
pls try this
Card_Value =
IF( ISFILTERED('Date'[Year])&&ISFILTERED('Date'[Period]),
"Selected Year is : " & FORMAT(SELECTEDVALUE('Date'[Year]), "0") &" And "&"Selected Range is for Period: " & MIN('Date'[Period]) & " - " & MAX('Date'[Period]),
"Selected Year is : " & FORMAT(SELECTEDVALUE('Date'[Year]), "0")
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |