Infographic using Power BI

With more demand and acceptance of data visualization, we have to deal with different kind of audiences. Some of those are not having analytical minds and simply grab information through graphics and cosmetics. There is also a need of awareness for masses for which statistical analysis and graphs are sometimes too much for general audience. In this scenario Inforgraphic is the best candidate to address these concerns.

I have experimented a report baased on open data of the government entity DEWA of Dubai. The result was amazing and really provide a simple information about operations and customers’ segmentation.

Report can be viewed through following link

Click here to view

Dynamic Infographics

Using Tickers in Power BI

Tickers are useful when you want to show information in floating form. Almost everyone is used to ticker like visuals in reporting as in situations like stock exchange information, game scores, weather report, news headline or otherwise tickers are fairly useful.

Click here to see report in action. 

In Power BI we have limited possibilities of animated content like tickers. In order to produce ticker like visual, I have tried two different approaches.

  • Using Card Visual and Play Axis Custom Visual
  • Using SVG through HTML Viewer Custom Visual

 

Using Card Visual and Play Axis Custom Visual

Ticker Power BI

In this method I have created different custom columns and measures.

“What if parameter” was used to create a table to help in animation of the text.

Length = GENERATESERIES(0, 150, 1)

“Ticker” measure was used to create content for ticker which will run from left to right. DAX REPT was used to create empty spaces on the right side as card visual always keep text in center. While next measure “LeftToRightTicker” will add spaces to the left of the ticker content based on changing values of “Length Value” in response to Play Axis visual. You can set play axis animation settings based on your needs.

Ticker = CONCATENATEX(VALUES(Outlets[CityOutlets]), Outlets[CityOutlets], ” | “) & REPT(” “,60)

LeftToRightTicker = REPT(” “, Length[Length Value]) & [Ticker]

Play Axis visual was used to change values in Length table created through “What if parameter”.

Using SVG through HTML Viewer Custom Visual

tickers in power bi

In SVG example, HTML is generated through custom columns for both simple and TV like visual. A custom column “Ticker” is used to create concatenated text for use in ticker which is ingested in the HTML to produce ticker.

SVGContentSimple = “<svg width=””100%”” height=””100″” style=””background: white””>

<text x=””10″” font-size=””10pt”” y=””50″” fill=””black”” >” & SummaryTable[Ticker] & ” 

<animate attributeName=””x”” from=””-120%”” to=””120%”” dur=””25s”” repeatCount=””indefinite”” fill=””freeze”” >

</text>

</svg>”

Source file can be reviewed for more details. Click here to download.

Reference for SVG images used in this example http://thoughtbot.github.io/foundry/

 

 

 

 

Using Unicode Characters in Axis and Slicers

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.

Snapshot

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

Item code Item Unichar
100 Coffee 127854
101 Ice Cream 127846
102 Soup 127861
103 Pizza 127829
104 Donuts 127849
105 Burger 127828

 

Table Name: Reaction

Rcode Reaction Unichar
1 Smiley 128578
2 Sad 128542
3 Neutral 128528
4 No Feedback 128566

 

Table Name: Responses (Only few rows shown here. Check Excel file for full list)

ItemCode Rcode
100 1
100 1
101 1
101 2
101 2
101 3
101 3
101 3
101 4
101 4
101 4
101 4
101 1
101 1

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

IconAndReaction =
ReactionDefinition[ReactionIcon] & UNICHAR(10) & ReactionDefinition[Reaction]

 

Following is the snapshot of relationship.

Model Snapshot

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

Unichar Example from EZPowerBI.com

Click here to see report in action View Power BI Report

For finding appropriate Unicode characters check the following links.

http://xahlee.info/comp/unicode_index.html 

https://www.vertex42.com/ExcelTips/unicode-symbols.html

Will be sharing more examples in future.

Subscribe to my blog for more surprises!

Cheers!

 

Fuzzy Matching / Merge – Power BI

A new video is recently added by EZPowerBI.com to explain Fuzzy Matching / Merge feature of Power BI. This is understood that this feature is presently in preview stage but it is fairly important as there are lot many use cases where you have to merge data where you can expect variations in connecting table. This can be resolved through fuzzy merge logic implemented in Power BI. You cannot say that the accuracy is perfect but it will save you a lot from extra efforts needed to clean your data in such scenarios. This video is highly recommended for those who want to get hold of this feature at this stage. Subscribe to my YouTube Channel as well as this site to keep watching up to date contents.