Dynamic Bar Chart Coloring: Adjusting Color Based on Slider

Anonymous — Fri, 08 Mar 2024 13:14:49 GMT

I want to dynamically change the color of individual bars on a bar chart based on the survey selected in a slider. However, I'm encountering difficulties as the data is organized in different columns of the table, leading to all bars changing colors instead of just the selected one.

Survey one has survey code 1, etc. So if you select survey 9, the only bar that changes color is the "good_quality" bar, and if you select survey 5, the only bar that doesn't change its color is the "Good_contact" bar. The color for the bars that correspond with the answers of the survey will become green, and the bars that are not selected are red.

The data structure looks as follows:

The dashboard looks as follows

Re: Dynamic Bar Chart Coloring: Adjusting Color Based on Slider

lbendlin — Fri, 08 Mar 2024 22:46:34 GMT

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

topic Dynamic Bar Chart Coloring: Adjusting Color Based on Slider in Custom Visuals Development Discussion

Dynamic Bar Chart Coloring: Adjusting Color Based on Slider

Re: Dynamic Bar Chart Coloring: Adjusting Color Based on Slider