Forum Discussion

sdhn's avatar
sdhn
Icon for Responsive Resident rankResponsive Resident
4 years ago
Solved

Display color on Chart Bar

Hello All,

 

I have  a measure as below:

 

 Deployed % = DIVIDE ('Tenable'[NAD],[TED],0)

 

I want it displays "DARK GREEN" on bar. 

 

NAD amnd TED are also simple measure.  Getting total values from the columns. 

 

Any help will be appreciated. Thanks 

  • Hi, 

    According to your description, I can roughly understand your requirement, you want to change the color on the top Bar, right? I think you can try the visual clustered bar chart, you can set the bar color for your data points in the chart based on your requirement.

    This is the test data I created based on your description:

     

    And you can get what you want.

    You can download my test pbix file below

     

    If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

    How to Get Your Question Answered Quickly 

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

    • sdhn's avatar
      sdhn
      Icon for Responsive Resident rankResponsive Resident

      Only to the BAR , somehow not able to change color on top Bar.  Values are coming from measure on top Bar and it is in % format.  Below BAR values are coming from calculated column and it is on Whole Number format. 

  • v-robertq-msft's avatar
    v-robertq-msft
    Icon for Community Support rankCommunity Support

    Hi, 

    According to your description, I can roughly understand your requirement, you want to change the color on the top Bar, right? I think you can try the visual clustered bar chart, you can set the bar color for your data points in the chart based on your requirement.

    This is the test data I created based on your description:

     

    And you can get what you want.

    You can download my test pbix file below

     

    If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

    How to Get Your Question Answered Quickly 

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.