Apply Conditional Formatting to a Column and am seeking assistance
Hello All, I would like to apply conditional formatting to a column and am seeking assistance. My goal is to enable users to select a color that will automatically be applied to a column header in Power BI, based on data sourced from Excel. For instance, if a user selects '1', the color should be green; for '2', blue; and for '3', red. Please be aware that the report is updated monthly. Therefore, as users change values in Excel each month, these changes should be dynamically reflected in Power BI. I'm facing a challenge with applying conditional formatting to a column instead of a row. If you have a more effective way to model the data, your suggestions would be greatly appreciated. My brain is a bit fatigued, just want to see column conditional formatted.😁 Can anyone provide a solution for this? I have included a screenshot below for better clarity.
Calculate column error
Hi! I created a measure and it doesn't work completely. Can you help me solve it? I copy the measure below the image. COLUMN "% Cob. Cuota 1" < 60% (does not apply INCENTIVO) Thanks for your help. Best regards, Guillermo.- Incentivo = VAR _ObjetivoVentas = RELATED(Tabla_Agentes[Objetivo_Venta_1]) VAR _ObjetivoCobranza = RELATED(Tabla_Agentes[Objetivo_%_Cobranza]) VAR _PorcCobCta1 = DIVIDE('L 1613'[PorCobCuo1], _ObjetivoCobranza) VAR _PorcVenta = DIVIDE(Totales[Total Vendidas], _ObjetivoVentas) RETURN IF( _PorcCobCta1 >= 1 && _PorcVenta >= 1, IF( _PorcCobCta1 >= 1 &&_PorcVenta >= 1.2 , RELATED(Tabla_DIM_Incentivos[Incentivo_2]), RELATED(Tabla_DIM_Incentivos[Incentivo_1]) ) )
How to reset count where yyyymm Date gaps exist
How can I add a condition to the below dax to identify the gap between 202209 and 202305 and reset the count? -- Calc Column Active_records = var _GP = Table[GP] var indv_id = Table[ID] var _end_date = Table[DATE] var _DATE = EOMONTH(_end_date,-24)+1 VAR _COUNT = RANKX ( FILTER (ALL(Table), Table[GP] = EARLIER(Table[GP]) && Table[ID] = EARLIER(Table[ID]) && Table[MALES_UNDER_35] = EARLIER(Table[MALES_UNDER_35]) && Table[DATE] >= _DATE && Table[DATE] <= _end_date ), Table[DATE], , ASC, Dense ) RETURN _COUNT
