Create Bullet Chart with Custom Data Label Placement Visual for Power BI

Create Bullet Chart with Custom Data Label Placement Visual for Power BI


Prerequisite:

  • Sign up for PBIVizEdit
  • Create sample data in CSV

Steps:

  1. Visit https://pbivizedit.com/gallery/bullet-chart-with-custom-label-placement and click on modify visual.

Bullet Chart with Custom Data Label Placement

  1. If you have already signed up in our tool you will directly go to the Bullet Chart with Custom Data Label Placement editor.

Bullet Chart with Custom Data Label Placement
Else, you have to first register with our tool and after you log in you will first come across Visual Editors page.

Bullet Chart with Custom Data Label Placement
From Visual Editors page, you can go to library, choose the Bullet Chart with Custom Data Label Placement visual and import the visual.

Bullet Chart with Custom Data Label Placement Once you click on import, you will be directed to the Bullet Chart with Custom Data Label Placement editor.

3. Upload your sample data (.csv files only) under Data tab using Upload csv button. For more details go to How to import data

Bullet Chart with Custom Data Label Placement

  1. Map your dimensions to axes available under Data Attributes.

e.g. – Based on the data taken in the sample
  • Series 0 (Bar): X Axis = Current Sales, Y Axis = Brand
  • Series 1 (Bar): X Axis = previous Sale, Y Axis = Brand
  • Series 2 (Bubble): X Axis = Saliency%, Y Axis = Brand
    For more details go to Data Attributes

Bullet Chart with Custom Data Label Placement

  1. You can check the visual after mapping under Visual tab.

Bullet Chart with Custom Data Label Placement

  1. If you want to make changes in the visual attributes, you can make them under Visual Attributes section.
    Few attributes that can be changed for Bars and bubble(used as target line here) are:
    • Bar colors
    • Bar width and transparency
    • Marker color, size and type
    • Legends
    • Tooltip
    • Spacing and lot more.

Bullet Chart with Custom Data Label Placement
For custom data placement, you can place the labels inside, outside or in the middle of both the bars. You can also use customised data labels using our label template.

Bullet Chart with Custom Data Label Placement

To know more about visual attributes, check Visual Attributes section.

  1. Once you get your desired custom visual, click on Export visual button to export it.

Bullet Chart with Custom Data Label Placement
Update the visual properties and choose the properties you want Power BI formatting panel to display under Format tab. Once you have set the visual properties, fields and format, click on Export Visual button.
To know more about the visual properties, fields and format, check Export Visuals section.


Note - Free visuals will expire after 3 months from the day of export. If you want to use the visual for a longer period, we would suggest you to buy the visual.


  1. After exporting, import the .pbivizfile into the Power BI and use them in your dashboards.

Bullet Chart with Custom Data Label Placement

Bullet Chart with Custom Data Label Placement