Forum Discussion

Boveitj's avatar
Boveitj
Frequent Visitor
9 years ago
Solved

Hide Card Values until that Value Type is selected on the Chart?

Example: I have a chart that tracks operators performance with most of the charts having operators name on the x-axis and a performance metric on the y-axis. When the dashboard is loaded, a random name populates the card visual which I would like to show as just a blank card until an operator is selected. I use this card so operators names can be read since often times they are small or cut off on the chart. 

  • Anonymous's avatar
    Anonymous
    9 years ago

    Write a measure and use that on the card.

     

    Selected Operator = IF(
	HASONEVALUE(TableName[OperatorName]),
	FIRSTNONBLANK(TableName[OperatorName], 1),
	" "
)

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Write a measure and use that on the card.

     

    Selected Operator = IF(
	HASONEVALUE(TableName[OperatorName]),
	FIRSTNONBLANK(TableName[OperatorName], 1),
	" "
)