topic Re: Display color on Chart Bar in DAX Commands and Tips

Display color on Chart Bar

sdhn — Tue, 15 Feb 2022 23:23:01 GMT

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

Re: Display color on Chart Bar

VahidDM — Wed, 16 Feb 2022 00:11:46 GMT

HI sdhn

Can you add more details? Do you want to add "Dark Green" as a text or as a color in the bar chart?

Check this : https://www.vahiddm.com/post/add-dark-and-light-modes-to-your-power-bi-report

Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: Display color on Chart Bar

sdhn — Wed, 16 Feb 2022 00:37:09 GMT

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.

Re: Display color on Chart Bar

v-robertq-msft — Fri, 18 Feb 2022 08:43:25 GMT

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.