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
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 ) )
DAX query required for IF and IF Else condition of below case
Hi Team, I am new to PBI, help me with this case! IF type(col) = "AAA" & Date time(col) < 11AM then Pickup date = Date(col)-1 ELSE Pickup date = Date(col) IF type(col) = "BBB" then Pickup date = Date(col)–1 IF type(col) = "CCC" then Pickup date = Date(col) Value of "AAA" is having AAA_a, AAA_b, AAA_c, AAA_d, AAA_e ----AAA_n etc. So here we are calling the condition with "AAA". How do we calling "AAA" with one IF condition statement or any other. Same like value of "BBB" & Value of "CCC". Here date time(col) contains 24hrs, we required less than(< )upto 11AM then Pickup date = Date(col)-1, else Pickup date = Date(col). Here Date(col) is calculated column. So, kindly helpe me with the DAX query. below is the snapshot for your reference.SELECTEDMEASURENAME() and SELECTEDMEASURE() in field type Conditional Formatting
Dear all, I'm trying to build a measure called [_Colours] that allows to apply a different combination of colours depending on the selected measure I have by using a field type CONDITIONAL FORMATTING and SELECTEMEASURENAME() and SELECTEDMEASURE() functions but it seems that those doesn't works into a conditional formatting: the goal is to avoid to create an specific conditional formatting for each measure. Any suggestion? Thank you in advanced
