topic How to I enable conditional formatting on a Power BI ribbon chart? in DAX Commands and Tips

How to I enable conditional formatting on a Power BI ribbon chart?

Anish7117 — Wed, 28 Aug 2024 02:13:30 GMT

I have a PowerBI project where I am using a ribbon chart.

The X- axis field contains the subjects (English, Science and Mathematics)

The Y-axis field contains the average scores

The Legend field contains the Name of Students

I have attached a sample Image:

What I want to implement is, I want to include a slicer where if I select the name of a Student, the color of the corresponding student ribbon turns to red, else it remains grey.

Power BI is not allowing me to apply conditional formatting and therefore, I am forced to use the manual color selection for every ribbon. How can I achieve the functionality?

Thanks

Re: How to I enable conditional formatting on a Power BI ribbon chart?

mark_endicott — Wed, 28 Aug 2024 10:40:45 GMT

Anish7117 - There is no easy way to do this in Power BI, but it is possible with a workaround.

Most of the technique for this is shown in the video linked here: https://www.youtube.com/watch?v=_GOIflxSlYI

However, I would not suggest you use two visuals for this, I would suggest you put both measures in the same chart so that the one you wish to colour is on top of the grey ribbons. There is a bit more about this process here: https://www.youtube.com/watch?v=rldduQrW83Q - But again, you will not need to use this whole process, this will just be showing you how to add multiple measures.

Both videos are for a line chart, but it will also work for a Ribbon chart.

If these ideas work for you, please accept this as a solution. It helps with visibility for others with the same challenge.

Re: How to I enable conditional formatting on a Power BI ribbon chart?

Anonymous — Fri, 30 Aug 2024 09:09:38 GMT

Hi Anish7117 ,

As far as I know, if you add column into Legend of visual, Power BI will give the color based on the Legend automaticlly. This is by desgin.

If you still want to change the color dynamiclly, I suggest that you can add student into small multiple or X aixs instead of Legend.

Create an unrelated Student Table.

DimStudent = VALUES('Table'[Student])

Measure:

Measure = IF(ISFILTERED('Table 2'[Student]),IF(MAX('Table'[Student]) in VALUES('Table 2'[Student]),"Red","Gray"),"Gray")

Add this measure into columns color.

Result is as below.

Best Regards,
Rico Zhou

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