Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi
I am trying to figure out a way to make the background of my card visualization more dynamic.
As can be seen here. I'm using values from column name Previous week entry status to display whether the user has submitted the form or not. If the user haven't submitted the form it will display yes with the background color of red. On the contrary, if the value is blank then the background should be green and I would like to replace "blank" with another words. Is it possible? If not can I create custom visual to make this works? thank you all of you guys in advance.
Solved! Go to Solution.
Card Message =
VAR card_value = SELECTEDVALUE('my table'[my column])
RETURN IF(ISBLANK(card_value),"No Value",card_value )
Help when you know. Ask when you don't!
Try using a measure instead of a column to provide the value for the card. Inside of a measure you can test for a blank result and substitue the text you want instead of blank. If the column is not blank, then just have the measure return the value from the column.
Help when you know. Ask when you don't!
Could you give me some example of the measure idea. Should I use "If" or something else?
Card Message =
VAR card_value = SELECTEDVALUE('my table'[my column])
RETURN IF(ISBLANK(card_value),"No Value",card_value )
Help when you know. Ask when you don't!
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |