Color Picker without color palette, need to have only conditional formatting button
Hello All, I am currently working on custom visual formatting pane to add a color picker without the color palette button (color dropdown next to `fx` button), just need to have conditional formatting button (this fx button) Current UI looks like Expected (This is from Table visual > Format Pane > Cell Element Card) I am currently using "Color Picker slice" and this is my code in capabilities "objects": { "values": { "properties": { "conditionalColor": { "type": { "fill": { "solid": { "color": true } } } } } } }Create Conditional Formatting Group
Hi, I'm trying to create a Conditional Formatting Group in the Customization tab like in the table visual: I thought I may be able to use the ConditionalFormattingControl as the Formatting Component but couldn't find anywhere how to insert it to the pane. Can someone provide an example on how to create something similar? Is it even possible? I want to create a status field that can be formatted as we do in the table visual, so I will want to know how to apply those to my Visual. Thanks in advance!
Conditional formatting matrix for Multiple Columns based on week
Hi! Hopefully someone can help. I am struggling to recreate something that was previously done in excel into a Matrix visual in one of my reports. Basically, I am trying to display gradient colors using conditional formatting based on the values for multiple columns. In excel, we used conditional formatting for each individual column multiple times. When I attempt to use conditional formatting in Power Bi, the entire dataset is used in the gradient rather than each individual column. I have also tried creating a color table using dax and then use a gradient color measure within field value but the colors are all over the place. Does anyone have any suggestions?
Conditional formatting color on x-axis label
Hi All, I'm working on bar chart with x-axis contain year & week arrangement. I want to apply some conditional formatting on x-axis label to give indication of particular week, ie. week 43 with different color against the rest. i have arrange additional column 'cweek' contain '0' and '1' to differentiate current week vs the rest. However, when i apply conditional formatting, with any method, turns out all the color still same and no difference on current week. (gradient, rules, field value with column 'cweekcol'). Any idea how to work on conditional formatting or 1-0 condition cannot work here? i prefer to apply coloring in the x axis label, not the data label, bar to ensure the color is there even when the data is zero (bar not shown). conditional_formatting_color_xaxislabel thanks in advance.Change row heading font colour but not on all rows
Hi all, as the title suggests I'm trying to change matrix table "Medium" row headings to orange and the "Large" to red. I don't want to apply conditional formatting to the coloumn values only those headings in particular. The other row headings (Lead, Qualify, Small etc) should remain black. Is this doable? Many thanks
Conditional color by comparison
Hello, I was wondering it was possible to create something like the below table in PowerBI (it was created in Qlikview). The table compares results for different scenarios. the expression is just 'sum of [Quantity]'. For clarity the fields used in the table are: Scenario ID (dimension) Year (dimension) Quantity (fact) when a single scenario is filtered the cells for the scenario have a yellow background. red and green color formatting is then used for the table cells for the other scenarios; green if the number in the cell is higher than the selected scenario and red if it is a lower value. This is calculated at year level rather than at a total level as can be seen in the image. any help? much appreciated PHinsHow to make conditional number format depending on data fields
I like to create a matrix visual from a dataset like this: Month Value Target Operator Unit 2022-01 10 5 >= seconds 2022-02 0,53 0,4 <= % ... In my matrix visual, numbers should be representet with their associated number format (unit) and colored depending whether in target or not using the operator so in the end it should look like that: Month Value 2022-01 10secs 2022-02 53% ... How can I achieve that, using some kind of conditional formatting. I need a rule for different number formats (like seconds, hours, percent, decimal, date, Euros, Dollars etc.) and operator (>= and <=)
