How to Display Text in Card Visuals
In some scenarios, you may want to display text or other non-numerical data in a card visual. This could be useful for displaying the top agent according to sales, or the date when the data was last refreshed. This article will guide you through the steps to achieve this.
Steps to Display Text in Card Visuals
-
Drag and Drop the Number Card Widget: Start by dragging and dropping the Number card widget onto your dashboard. In the Assign Data tab, drop the required dimension field. For example, if you want to display the top product according to sales, you would drop the ‘Product Name’ field.
-
Hide the Value Field: In the Value field of the card, you can drop any columns (either measure or dimension). Since we are going to hide this value, it doesn’t matter what you choose. Navigate to the Properties tab and uncheck the ‘Show Measure’ checkbox. Now you should only see the Series field and header of the card in the Number card widget.
-
Apply a Filter to the Series Field: Navigate back to the Assign Data tab and open the filter window of the series field.
-
In the Filter pop-up window, choose the ‘Rank’ option and set ‘Count’ as 1 to view the top one data. From the Column drop-down, choose the required measure field (for example, ‘Product Name’) and save it.
After applying the filter, you should see the top one product name only in the card widget.
-
In the Filter pop-up window, If choose the ‘Rank’ option and set ‘Count’ as 1 to view the last one data. From the Column drop-down, choose the required measure field (for example, ‘Product Name’) and save it.
After applying the filter, you should see the last one product name only in the card widget.
Conclusion
By following these steps, you can display text or other non-numerical data in a card visual. This can be useful for displaying dynamic information that changes based on your data, such as the top product according to sales or the date when the data was last refreshed.
References
