The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |