Microsoft Power BI

Chiclet Slicer_ A Custom Visual in Power BI

Power BI has some very useful and interactive visualizations that enhance the dashboard’s meaning, Chiclet Slicer being one of them.

These are slicer buttons that you can arrange either horizontally or vertically for efficient real estate use. Using the formatting tools, you can specify the number of rows and columns in the slicer. Not just that, you can also include images in your slicers, along with cross -filters.

So, in short, Chiclet Slicer forms a compact package of awesomeness!

Importing the visual from the Microsoft Power BI AppSource

It is among one of the many Custom visuals of Power BI that we need to be download separately before we can use it.

  1. Download the Chiclet Slicer from the following link: https://store.office.com/addinsinstallpage.aspx?rs=en-001&assetid=WA104380756
  1. Import it in your Power BI desktop by following the given steps
  2. Click on the three dots (highlighted)
  3. Click on “Import a visual from a file.”
  4. Click on Import
  5. Once imported, it will reflect as highlighted:
Contact us for interactive dashboards and quick database solutions.

Using Chiclet Slicer without Images

Now that our Chiclet Slicer is imported let’s see how to use it in our dashboard.

  1. Click on the Chiclet Filter
  2. Select the Dimension that you want to use in the filter
  3. Your filter is ready; you can change the formatting from the Format section.

But, to make it visually more appealing, let’s use images. (In the given example, I have used Country as the slicer, so I am using the flag of the respective countries)

Using Images from the Internet

  1. Create a separate table for Image URLs
  2. Once the URLs for the individual images are posted in the respective columns of the table, draw a relationship between the Data table and the URL table
  3. Follow the steps for creating a Chiclet Slicer graph using the new table

 

Images from the Local Drive

Since Power BI desktop works with online images, using images from the internet is easier than using images from the local drive. But, if you want to use local images in Chiclet Slicer or any other Power BI visual, here are simple steps for you:

  1. Go to edit queries
  2. Create a blank query
  3. Go to Advanced Editor of the blank query and use the following M-Script

let

BinaryToPbiImage = (BinaryContent as binary) as text =>

let

Base64 = “data:image/jpeg;base64, ” & Binary.ToText(BinaryContent,BinaryEncoding.Base64)

in

Base64

in

BinaryToPbiImage

  1. Click on done
  2. Click on New Source
  3. Select Folder and Connect
  4. Browse the folder where you have stored the Images
  5. Click OK to get all the stored images imported
  6. Now, Invoke the query to convert local images to Base64, by clicking on Add Column
  7. Then select Invoke Custom Function
  8. Name the New Column that you want to create for the Binary Images
  9. Select the Function Query name that you want to Invoke
  10. From the Dropdown Select the Column on which the Function will be applied, i.e., the first Column named as Content
  11. Click OK
  12. Make sure that you name your images correctly, and they can be used to draw a relationship with your existing tables.
  13. The Name Column can draw a relationship with your existing tables, but you need to remove the extensions. To do so, right-click on the Column, select Split by Delimiter. Check if period (. ) is selected as the delimiter. Click OK. Now you have the Unique names column ready.
  14. Close and apply
  15. Go to Relationships and check if the relationship between this new Column has been established with your data table’s existing column. If not, create the connection.
  16. Once that’s done, you are ready to use your local drive images in your dashboard and build a Chiclet Slicer.

Contact us for any queries.

 

 

 

 

Business Intelligence

Best practices to create an impactful BI dashboard for your company

To impart crucial information to the decision-makers in the most readable formats, you must embrace a BI dashboard – the new age data visualization and analysis tool.

Using a digital dashboard, you can collate and analyze critical information across an organization. With the real-time snapshots, trends, and key-performances, you can exactly know the current position of your organization and derive modules from enhancing the performance of each department.

But, until you utilize this powerful tool effectively, it will not give the desired results, and it can also impact the decisions of the management negatively.

Our company consisting of experienced BI experts can help you from the trauma of failed dashboards.

Top Five Best Practices

Identify the purpose and target audience

As we do for any reporting, first identify the 5Ws – knowing why you are developing the dashboard and for whom helps you to set the backdrop. Once you know your stakeholders and their requirements, you will precisely know what data they are expecting from your dashboard.

Don’t forget that the purpose of BI dashboards is to see the real-time data clearly so that the right decisions can be taken at the right time.

Focus on communication and not just visuals

You must be aware that the BI tools like Tableau and Power BI are known as data visualization tools because using their interactive graphs and charts, you can present numbers that are readable and decipherable.

So, while visuals play a vital role, when these do not communicate the desired facts, they are of no use. You must know the purpose of each graph and utilize them strategically.

Big data analysis

Cloud-based BI dashboards are the need of the hour

If you cannot share your dashboards on the cloud, how will you ensure that the data you are presenting is centralized, governed, and thus trustworthy?

When everything else in your organization, starting from CRM to the HR system is online, why not the dashboards?

Web-based BI gives you close to accurate information that empowers you to realize an opportunity or avoid a crisis. The decision-makers can communicate on a real-time basis and take prompt actions.

Do not clutter your dashboards

Communication is a science – remember it when designing your BI dashboard. It must reflect prompt, accurate, concise, and fact-based communications. One of the mistakes that most data professionals make is to overburden the audiences with cluttered information.

Follow the 5-second rule  – the audience should get the relevant information in about seconds! It shouldn’t be like “finding a needle in a haystack.”

Provide data context

Data analyses and visual representations without the data context will not be meaningful. Imagine the impact you may have when you show sales figures, without mentioning Dollar or Pound, or if you show sales over a period of time without drawing any reference to the time frame!

A piece of information that doesn’t hold in the current scenario is of no value, and there’s hardly any point in analyzing it. Therefore, to reflect the current trends and challenges, the selected data metrics must be up-to-date.