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.Colorizing/formatting a line up to today's date
I want to color the line of a chart up to a defined date. The rest of the line should be dashed. For this I have already created two lines and superimposed them to format them differently. However, the end of the first line is disturbing, because a horizontal line is created. Is it possible to hide the tail? or to format the same line to defined data sections?Conditional Formatting/Coloring Values
Hello all! I have created a matrix and a table on the same tab of a Power BI Report. (See 1st picture below) The table on the left uses conditional columns which I manually inserted into the table. (For example: If the time is 8:00 AM, then 15 staff is then 49, and so on and so fourth). Both visuals are useing the same times. The values in the matrix are using a column called StudentID, and the values are as Count (Distinct). I was asked to find a way to color the values on the right as follows: If the Value is above the 5 Staff number, then color it Green If the Value is below the 15 Staff number, then color it Red Ex: On January 25, 2022 the value is 30. This value would be Red If Value is in between, then color is Yellow Here is an example of the data I am using Time Date StudentName StudentID College CreditHours 15 Staff 5 Staff 8:00 AM January 27, 2022 Joseph Mann 005866 Business 14 49 51 9:00 AM January 29, 2022 John Doe 447856 Business 16 77 79 9:30 AM January 25, 2022 Jane Doe 555013 Law 18 70 72 10:00 AM January 25, 2022 Ryan Pierce 554876 Graduate 16 61 63 8:00 AM January 26, 2022 Jannette Richardson 332146 Education 15 49 51 12:00 PM January 27, 2022 Dameon Travis 958741 Business 15 45 47 2:00 PM January 28, 2022 Marney Phillips 004584 Education 15 63 65 I am not really 100% sure how this would be able to get formatted the way I am being asked. Would this be using Variables in a calculation? I struggle so much with variables and some DAX Functions. I've tried to do drop down on the values and conditionally format, however that really didn't work for my case. I did attempt to do conditional formatting. However with the rules, I am not able to do conditional formatting based on both 15 Staff and 5 Staff. So it is being sort of odd with it because I am trying to compare the Value between both 15 and 5 Staff. Is there some sort of DAX Expression that can maybe be written to compare the value between both 15 and 5 Staff?
