topic Re: Dynamic Formatting Area chart in DAX Commands and Tips

Dynamic Formatting Area chart

Anonymous — Fri, 06 Sep 2024 15:49:37 GMT

Hi,

I want to create an area chart that changes to red(area and line color) when a measure is negative and be green when positive like this:

Is there a way to do this in powerbi or a custom visual i cannot find anything.

Thanks!

Re: Dynamic Formatting Area chart

lbendlin — Fri, 06 Sep 2024 21:30:05 GMT

yes, this can be implemented. Is the static horizontal line not enough?

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Dynamic Formatting Area chart

FlipFlop1 — Sun, 08 Sep 2024 15:53:48 GMT

Not the full solution, but half a solution:

Conditional formatting is available for bar charts, but I can't see it for line or area charts.
You can start with a column chart and set the conditional formatting under Visual > Columns > Color as follows, using a field with the color hex in your table (click on the FX button and select field value and then the hex color from your table).

This will give you a bar graph with conditional coloring as follows:

If you then change the graph to Line, it retains the colors as the markers, but not for the line.

There doesn't appear to be a marker setting, but it does seem to work.