I recently did an experiment with Power BI report by using “Unicode characters” which was shared on LinkedIn. In this example I used selected characters in slicers and axis instead of text. This has created lot of interest among followers and received numerous requests to share details.
In reality it is a fairly simple approach where different Unicode characters were selected for different items and reactions used in this example.
Following three tables were created in Excel which were used in this report. For each dimension table I have added Unicode to represent icon.
Table Name: Serving
Table Name: Reaction
Table Name: Responses (Only few rows shown here. Check Excel file for full list)
After importing excel sheet in Power BI I have added couple of calculated columns and measures. To create icon I have used following DAX.
For Item Icon to be used for Axis
ItemIcon = UNICHAR(ItemDefinition[Unichar])
For Item Icon and name to be used for slicer
IconAndItem = ItemDefinition[ItemIcon] & UNICHAR(10) & ItemDefinition[Item]
Similar is used for calculated column for Reaction icon.
ReactionIcon = UNICHAR(ReactionDefinition[Unichar])
For Reaction Icon and name to be used for slicer
ReactionDefinition[ReactionIcon] & UNICHAR(10) & ReactionDefinition[Reaction]
Following is the snapshot of relationship.
You may download sample excel file and PBIX file to evaluate more. This example is just to show how you can implement Unicode character. There can be numerous implementations and scenarios where icons can add value to your visuals and keep your report simple to grab the information easily.
To download only Excel file click the following link ReactionData
Complete files including PBIX can be download through the following link
Click here to see report in action View Power BI Report
For finding appropriate Unicode characters check the following links.
Will be sharing more examples in future.
Subscribe to my blog for more surprises!