Power BI

Completed

Set Colors and Conditional Formatting in visuals

Vote (611)

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)

on 15 Jun 2021 17:22:36

RE: Set Colors and Conditional Formatting in visuals

FitBit

on 06 Nov 2020 05:47:18

RE: Set Colors and Conditional Formatting in visuals

I want to be able to write a question that says "Revenue - Tax over time" and have Q&A create the calculation for me on the fly.

c3cb1933 de2d-47f3-8aa0-d0a2821c5faf on 16 Aug 2020 03:56:25

RE: Set Colors and Conditional Formatting in visuals

Another example (for Azure usage data). What is the average daily cost? i.e. Sum(cost) / Sum(count of date). Could also be expressed as: What is the total cost divided by the total count of date?

It is not currently possible to get the result desired above.

The first query returns a line graph with a point for every day and the average record value within each day. The second query returns the totals for cost and day count but does not do the divide.

b9ec8c94 c5b5-49c6-98b9-19e735c6aefb on 16 Aug 2020 03:50:59

RE: Set Colors and Conditional Formatting in visuals

I to would like to perform a question that would allow me to do math functions for example. 'total r for q1 / total g for q1' = %

Thanks

b9ec8c94 c5b5-49c6-98b9-19e735c6aefb on 16 Aug 2020 03:48:06

RE: Set Colors and Conditional Formatting in visuals

I to would like to perform a question that would allow me to do math functions for example. 'total r for q1 / total g for q1' = %

Thanks

b9ec8c94 c5b5-49c6-98b9-19e735c6aefb on 16 Aug 2020 03:41:54

RE: Set Colors and Conditional Formatting in visuals

I to would like to perform a question that would allow me to do math functions for example. 'total r for q1 / total g for q1' = %

Thanks

b9ec8c94 c5b5-49c6-98b9-19e735c6aefb on 16 Aug 2020 02:23:50

RE: Set Colors and Conditional Formatting in visuals

I to would like to perform a question that would allow me to do math functions for example. 'total r for q1 / total g for q1' = %

Thanks

b9ec8c94 c5b5-49c6-98b9-19e735c6aefb on 16 Aug 2020 02:17:11

RE: Set Colors and Conditional Formatting in visuals

I to would like to perform a question that would allow me to do math functions for example. 'total r for q1 / total g for q1' = %

Thanks

c162c86b 8bf8-e811-a95c-000d3a4f33c1 on 05 Jul 2020 23:40:12

RE: Set Colors and Conditional Formatting in visuals

I am a Microsoft Partner and ISV and my customers and my employees are getting frustrated by the lack of attention to this obvious bug!!!! When trying to set the conditional formatting in a table visual, the formatting color changes do not work properly. How in the world do you mark this as COMPLETED? I am trying to foind the responsible party to address this bug to. This is unacceptable to mark something COMPLETE that is obviously flawed and unusable in the latest PBI release. I want this fixed now.

1bc8bf7d 3fb8-4770-bfc2-e313d104d26d on 05 Jul 2020 23:26:54

RE: Set Colors and Conditional Formatting in visuals

Dynamic color mapping of numerical values, which will help us set the values of colors based on the range they are present in.

1
2
3
4
5
6
7
8

Merged Idea (2)