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

7595b6b9 e1c0-4f86-9346-40a10627ab10 on 05 Jul 2020 22:01:04

RE: Set Colors and Conditional Formatting in visuals

IT would be nice to have Red, Yellow, green be assigned by a value

Amanda Cofsky's profile image Profile Picture

4407b411 4356-404b-a828-29d2733a4422 on 05 Jul 2020 22:01:03

RE: Set Colors and Conditional Formatting in visuals

Please let us know when this is developed!

Amanda Cofsky's profile image Profile Picture

e236196f 4c15-4c5d-ad85-35d32007b3da on 05 Jul 2020 22:00:45

RE: Set Colors and Conditional Formatting in visuals

Additional to customization with colors, it would good if we have option to show/hide data labels, title, legends like we have in powerview.

Amanda Cofsky's profile image Profile Picture

13ee2361 bc51-45fd-af64-eb0d18a246c5 on 05 Jul 2020 22:00:44

RE: Set Colors and Conditional Formatting in visuals

I was very excited about this product until I read this post. Agree with everybody that came before me: not being able to assign colors is a show stopper. Period.

Amanda Cofsky's profile image Profile Picture

226efe50 b1b3-4b3f-b5cb-1367cabf2903 on 05 Jul 2020 22:00:24

RE: Set Colors and Conditional Formatting in visuals

What is the release date for this update? Colors are critical to BI

Amanda Cofsky's profile image Profile Picture

fdf975f4 cc37-4714-8d22-6dbd82eb51f1 on 05 Jul 2020 22:00:13

RE: Set Colors and Conditional Formatting in visuals

Along these same lines it would be useful if you could customize the axis in terms of fixed or floating scales in addition to the formatting of the text. On my line charts the scale changes from product to product and "breaks" the continuity of the presentation.

Amanda Cofsky's profile image Profile Picture

f72d4dcb e23e-40a3-b832-c9e00b273be0 on 05 Jul 2020 22:00:10

RE: Set Colors and Conditional Formatting in visuals

Fully agree with this improvement. It is a show stopper for corporates if you cannot decide on your own colour theme.
This is also very important because the same measure should be in the same colour wherever it appears on the dashboard, reports or other visualisations.

Amanda Cofsky's profile image Profile Picture

d3143204 fc69-4521-aabc-27024249646d on 05 Jul 2020 21:59:49

RE: Set Colors and Conditional Formatting in visuals

Honestly, we're dropping PowerBI usage just because we can't customize this as per our Corporate UI Standards. When complete, can you please inform and we can evaluate again?

Amanda Cofsky's profile image Profile Picture

1f7f2711 5819-e611-80e2-c4346bad91c4 on 05 Jul 2020 21:59:44

RE: Set Colors and Conditional Formatting in visuals

RANT 'alerts'
How come MSFT did not pick up on this before? This should be a top priority and should be pushed to Power View on-prem.

Amanda Cofsky's profile image Profile Picture

4f15bf9a 7fa2-415e-964f-74e40fef66e7 on 05 Jul 2020 21:59:39

RE: Set Colors and Conditional Formatting in visuals

This is a key feature for many organizations and the reason for using other BI tools.

Merged Idea (2)