Hi All,
I have a slicer and I'm displaying year in it.
I want to display the selected value in a card and for that I have written a DAX like below.
Solved! Go to Solution.
Hi @AnandNamburi ,
SELECTEDVALUE will only show a value if there is one value selected. It's second argument is for displaying something else if there are more than one values. That said, selecting a range of numbers or dates means that there are more than one numbers or dates. I would use either MAX, MIN, LASTNONBLANK or FIRSTNONBLANK instead.
Hi @AnandNamburi ,
SELECTEDVALUE will only show a value if there is one value selected. It's second argument is for displaying something else if there are more than one values. That said, selecting a range of numbers or dates means that there are more than one numbers or dates. I would use either MAX, MIN, LASTNONBLANK or FIRSTNONBLANK instead.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
108 | |
75 | |
66 | |
50 | |
48 |
User | Count |
---|---|
164 | |
87 | |
77 | |
70 | |
67 |