Skip to main content

Power BI

Completed

Set Colors and Conditional Formatting in visuals

Vote (611) Share
Amanda Cofsky's profile image

Amanda Cofsky on 04 Oct 2014 01:20:39

Power BI's visualizations have colors assigned automatically. It should be possible to set a color when a value is reached (e.g. always show negative bars in red) or for a particular color in a legend (e.g. always show Microsoft datapoints as blue)

Comments (79)
Amanda Cofsky's profile image Profile Picture

d606f525 90c9-4cef-82aa-88a7c2340a07 on 05 Jul 2020 22:10:33

RE: Set Colors and Conditional Formatting in visuals

Kindly provide this feature for line chart as well.It would be really good...

Amanda Cofsky's profile image Profile Picture

d606f525 90c9-4cef-82aa-88a7c2340a07 on 05 Jul 2020 22:10:33

RE: Set Colors and Conditional Formatting in visuals

This feature should be available for line chart as well.

Amanda Cofsky's profile image Profile Picture

58439f09 5009-482a-8171-178e674d930c on 05 Jul 2020 22:09:04

RE: Set Colors and Conditional Formatting in visuals

This is great, but it's not available for all visuals. The matrix is very limited. I'd like to be able to use conditional formatting, kpi icons, change text, etc.

Amanda Cofsky's profile image Profile Picture

c0c080fb 8218-4309-b6e6-d3c928e77fb0 on 05 Jul 2020 22:08:01

RE: Set Colors and Conditional Formatting in visuals

Hi, is it possible please to be able to conditional format numbers displayed using the Card visualisation, for example if showing a negative value to be in red

Amanda Cofsky's profile image Profile Picture

29712dd3 ad47-4bae-8347-43f1d844c34c on 05 Jul 2020 22:05:14

RE: Set Colors and Conditional Formatting in visuals

The colour conditional formatting is not enabled for table / matrix, which is a critical feature as they form great part of number based reporting / visualization needs.

Amanda Cofsky's profile image Profile Picture

3d32df43 5f9b-4d6a-b163-08d20b6805e2 on 05 Jul 2020 22:03:53

RE: Set Colors and Conditional Formatting in visuals

it'd be great if we could set the colour based on an expression, similar to how we can with SSRS - also the ability to have indicators where you could beside the value. so that e.g. you could potentially compare the current value in the cell with a measure that has the previous 4 weeks.

Amanda Cofsky's profile image Profile Picture

f03b6c3a 0907-4f01-998e-6e06b0181b31 on 05 Jul 2020 22:03:13

RE: Set Colors and Conditional Formatting in visuals

Hey Will Thompson. Is there also an option that can link a color to a legend (e.g. name/country) or what not so that the color stays the same for all future tables and graphs I create?

Amanda Cofsky's profile image Profile Picture

920028b1 0208-4d97-b350-3f0a74523e77 on 05 Jul 2020 22:03:02

RE: Set Colors and Conditional Formatting in visuals

Could the colour formatting also be added to the table & matrix views in BI? I really want to apply some conditional formatting based on a RAG setup.

Amanda Cofsky's profile image Profile Picture

629a9b26 9694-49e7-898b-596fedba74bd on 05 Jul 2020 22:02:38

RE: Set Colors and Conditional Formatting in visuals

applicable only column charts? what about other visualizations?

Gauges and line graphs should have this.

Even the Cards pinned on the dashboard should have this feature as 'alerts's can be set for cards in iOS

Amanda Cofsky's profile image Profile Picture

5fc772f9 f9ba-43f5-89f3-e2ae3d50341a on 05 Jul 2020 22:02:35

RE: Set Colors and Conditional Formatting in visuals

can we change dashboard theams also ?

Merged Idea (2)