Conditional formatting for matrix column headers based on closed month
Hi all, I am working with a Power BI matrix where I have months (January–December) displayed as column headers, as shown in the screenshot. no value will display, only the column Kindly ask for below request solution Dynamically change the background color of the column headers If a month is financially closed → show green If a month is still open → show grey I have a DAX in my model (e.g., a measure or flag indicating whether a month is closed): Closed Month Flag = IF( SELECTEDVALUE('Time'[IsClosedMonth]) = TRUE(), 1, 0 ) so the challenge is only related to applying the formatting to the headers. Thanks for support!
Need help in using Field Parameter in Top N filter and Conditional Formatting
Hi, I have a report that has conditional formatting and Top N filter on a static measure named IRR and it works perfectly. However, I want to change the measure to dynamic and allow user to select among a few other measures like DPI, RVPI and TVPI. I have created a Field Parameter and add all measures to it. It works for the bar chart at the bottom. However, I couldn't get the conditional formating to work. Also, the Top N filter based on that field parameter is not working properly. Can you advise how can I fix them, please? Thanks in advance. URL of my Power BI Report: https://github.com/chris-kc-cheng/ftk-powerbi/blob/main/Private%20Markets.pbix
how can use measures for comperision in conditional formatting using power bi
I made two measures to find the sales amount for this day and the previous day. Now, I want to make a comparison between the amounts. I want to use an up arrow icon and a down arrow icon to show me which value is higher than the other. I mean like this I tried to use conditional formatting, but it is difficult to add a measure for comparison." what sould i do ?
Conditional Formatting to show colour grades dependant on a changing measure outcome
Hi there, I have a measure that is dividing the number of absent employees over the past year by the average headcount providing me an overall % of absent vs headcount. I have then added this % into a table and added in Teams where it then shows the % of absent employees by team. What I would like to format is the colour of the Team level % by the overall measure outcome. For example, lets say the companywide % of absent employees is 10%. Team X has a value of 5% in the table therefore can be coloured green as it is below the companywide overall number or 10%. Team Y has 20% so should be red. This format should change depending on the overall firm % so if it drops to 4% companywide, Team X would then turn red too. How do I do this please? I have been trying for a few days now to no avail! Thank you!
Conditional Format Blank Values for Specified Column
I am trying to create a DAX formula to conditionally format the blank values for a specified column. In the below visual, I want all the blank values under "Renovo", "6/24", and "%" to show as the trianglelow icon. Below is my formula: Color = IF( SELECTEDVALUE('Transactions Export'[Previous Month Filter])="Previous Month" && SELECTEDVALUE('Transactions Export'[Lender v3])="RENOVO" && ISBLANK([Transactions %]),"TriangleLow") No icons appear with my formula. How can I acheive the desired result?Conditional Formatting Only Active for Specific Column Value
I've created a row based conditional formatting DAX formula, but I don't want the conditional formatting to be active for the "Lender" column where Lender="COMP" Is there anyway that I can get my formula to ignore the values that fall under "Comp" so that they are not highlighted in any colors? In other words, I only want the "RF" values to be highlighted in colors. Below is more formula: Color = IF( NOT(ISBLANK([Transactions])), RANKX(CALCULATETABLE( ALLSELECTED('Transactions Export'[Lender])), [Transactions],,,Dense ) )
