How to Display Two Differently Formatted Data in a Card Widget

In a KPI card widget, it is not possible to provide different formats to the actual and target values since this would result in an improper variance value. Specifically, the actual value cannot be differentiated from the target value when different data formats are used.

Instead, you can use two Number Card widgets and a Line Widget inside a Combine Widget to show two differently formatted values in a single view. Follow these steps to achieve this:

Steps to Show Two Differently Formatted Values in a Single View

1. Drag and Drop Combine Widget and Text Widget:

   • Drag and drop the Combine Widget.
   • Inside the combine widget, drag and drop a Text Widget to add the required title.
     
     

2. Add First Number Card Widget:

   • Drag and drop a Number Card widget inside the Combine Widget.
   • Configure it with the required value field and set the required value format.
   • Set its Horizontal Alignment as Right.
     
     

3. Add Line Widget:

   • Drag and drop the Line Widget next to the first Number Card widget.
   • Enable the Vertical Orientation in the Properties tab to display a vertical line.
     
     

4. Add Second Number Card Widget:

   • Drag and drop another Number Card widget next to the Line Widget.
   • Configure it with the required value field and set the required value format.
     
     

5. Disable Show Shadow Property:

   • Disable the Show Shadow property of all widgets added inside the combine widget.
     
     

6. Preview the Dashboard

   • In Preview, you can view the result as follows:
     
     

By following these steps, you can effectively display two differently formatted values in a single view using a combination of widgets.

Additional References

• Configuring and Formatting Number Card Widget
• How to Configure Combine Widget
• Formatting Measure Type Column