Forum Discussion

donovan_smith44's avatar
donovan_smith44
Frequent Visitor
6 years ago
Solved

Formatting Bars in a Clustered Chart

Hi all,   I'm a total Power BI noob, so wanted to know if something was possible. I have this bar chart pictured:       The royal blue bars represented a target financial amount, light bl...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi donovan_smith44 ,

     

    We can also archieve your requirement in a build in clustered bar chart with trick. Create two measures as actually or amount, adjust the formula based on your own data model.

     

    Actually = CALCULATE(SUM('Table'[Value]),FILTER('Table',[Type]="2019"))

     

    Target = CALCULATE(SUM('Table'[Value]),FILTER('Table',[Type]="Other"))

     

    Then we create three more measures, put them and target into the value field of visual.

     

    <80% = IF([Actually]<0.8*[Target],[Actually],BLANK())

     

    80 - 95% = IF([Actually]<0.95*[Target] && [Actually]>=0.8*[Target] ,[Actually],BLANK())

     

    >95% = IF([Actually]>=0.95*[Target],[Actually],BLANK())

     

    You can also change the name of these measure.

     

    Then we can change the color of data for each measure

     

     

    We also provided a usage of bullet chart in the page 2 of sample pbix file.

     

     


    BTW, pbix as attached.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi donovan_smith44 ,

 

We can also archieve your requirement in a build in clustered bar chart with trick. Create two measures as actually or amount, adjust the formula based on your own data model.

 

Actually = CALCULATE(SUM('Table'[Value]),FILTER('Table',[Type]="2019"))

 

Target = CALCULATE(SUM('Table'[Value]),FILTER('Table',[Type]="Other"))

 

Then we create three more measures, put them and target into the value field of visual.

 

<80% = IF([Actually]<0.8*[Target],[Actually],BLANK())

 

80 - 95% = IF([Actually]<0.95*[Target] && [Actually]>=0.8*[Target] ,[Actually],BLANK())

 

>95% = IF([Actually]>=0.95*[Target],[Actually],BLANK())

 

You can also change the name of these measure.

 

Then we can change the color of data for each measure

 

 

We also provided a usage of bullet chart in the page 2 of sample pbix file.

 

 


BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • donovan_smith44's avatar
    donovan_smith44
    Frequent Visitor
    6 years ago

    Thank you. This is great. Will try.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    v-lid-msft  This is great. Do you know how to create a bullet chart with the green shading to the left, yellow in the middle, and red to the right? That would seem to make sense in some contexts where the more something is consumed, the more it moves in to the red area.

    • v-lid-msft's avatar
      v-lid-msft
      Community Support
      6 years ago

      Hi Anonymous ,

       

      We can change the colors in the setting as following picuture.

       


      BTW, pbix as attached.

       

      Best regards,

      Community Support Team _ Dong Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.