Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a card visual where the name of the filtered selection shows on the card when selected. By default the FIRST Name (alpha) shows up when nothing is selected. I was able to use the following so it shows (Blank) until something is selected in filter.
However, I'd rather it not say BLANK, can it say "Select Account" or something else? (Blank) looks out of place.
Here is what I used so I could get BLANK (and not the first account name as it was giving me) FYI-CodeCity2 is the name of my slicer
NameSelectCheck = IF (
ISFILTERED ( ABF[Codecity2] ) && HASONEVALUE ( ABF[Codecity2] ),
LASTNONBLANK ( ABF[Account Name], "" ),
BLANK ()
)
Solved! Go to Solution.
How about:
NameSelectCheck = IF (
ISFILTERED ( ABF[Codecity2] ) && HASONEVALUE ( ABF[Codecity2] ),
LASTNONBLANK ( ABF[Account Name]),
"Select Account"
)
Proud to be a Super User!
Paul on Linkedin.
How about:
NameSelectCheck = IF (
ISFILTERED ( ABF[Codecity2] ) && HASONEVALUE ( ABF[Codecity2] ),
LASTNONBLANK ( ABF[Account Name]),
"Select Account"
)
Proud to be a Super User!
Paul on Linkedin.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |