LOADING

Type to search

Custom Visuals in Power BI – Bullet Chart

To Know more about the Different Corporate Training & Consulting Visit our website www.Instrovate.com Or Email : info@instrovate.com or WhatsApp / Call at +91 74289 52788

Data Analytics PowerBI

Custom Visuals in Power BI – Bullet Chart

Share

In today’s blog I will explain about Custom Visuals in Power BI.

As we know we have bunch of built in visualization in Power BI under visualization pan such as bar chart, column chart, waterfall chart, tree map and many other visualizations. But according to our requirements, we need new visualizations. Power BI give us platform to use custom visuals. we can create our own custom visualizations and share with others in organization and outside world.

In Power BI we have lots of Custom visuals and we can import custom visual from market place.

we have a public custom visual website form Microsoft:

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals&page=1&src=office

Custom Visuals in Power BI - Bullet Chart 29

 

Today I will explain how to use Custom visuals.

1st of all we need to click ellipsis after visualization from same pan:

Custom Visuals in Power BI - Bullet Chart 30

Click on Import Custom Visual:

Custom Visuals in Power BI - Bullet Chart 31

 

Click on Import from marketplace.

It will open Power BI Visuals .

Custom Visuals in Power BI - Bullet Chart 32

From here we can select any custom visual and these are for free. Today I am taking Bullet chart to explain.

Click on Add button and Bullet chart visualization will be added in visualization pan in Power BI desktop

Custom Visuals in Power BI - Bullet Chart 33

Click on Bullet chart:

Custom Visuals in Power BI - Bullet Chart 34

Select and drag Target Profit under Target field value , Profit under Value field and Category under category value field:

Custom Visuals in Power BI - Bullet Chart 35

Click on Format option:

Custom Visuals in Power BI - Bullet Chart 36Enter values under  Satisfactory %,Minimum% , Maximum % fields:

Custom Visuals in Power BI - Bullet Chart 37

We can change color for chart :

Custom Visuals in Power BI - Bullet Chart 38

As we have used two terms for Category field and have hierarchy

Select Expand next level :

Custom Visuals in Power BI - Bullet Chart 39

Select Drill Up and this time select Show next level drill:

Custom Visuals in Power BI - Bullet Chart 40

 

From this bullet chart and their different color’s we can easily identify the Profit value (from black bullet) for each category/sub category and what profit value is good/satisfactory/very good for respective category/sub category on the basis of colors .

Tags:

You Might also Like

Leave a Comment

Your email address will not be published. Required fields are marked *