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!
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 ?
dynamic conditional formatting with virtual table and switch
Hi, im having an issue building dynamic conditional formatting on my visual (color columns) The reason why i need to build that are all spaces in between columns in a chart, if more trafo numbers are selected than the spaces gets bigger To do that i added a table with ColorID and HEX rgb. I want to build virtual table with all selected Serial Numbers from slicer, adding HEX rgb by matchin the ID from virtual table and colorID and then with switch return HEX rgb. The problem i have is that it always return same hex rgb with index nr 1 IndexColorTrafo = var CurrentSelection=MAX(MeasurementsByFrequency[Serial Number]) VAR SelectedTrafoIDs = VALUES(MeasurementsByFrequency[Serial Number]) VAR NumSelectedTrafoIDs = COUNTROWS(SelectedTrafoIDs) VAR VirtualTable = ADDCOLUMNS( GENERATESERIES(1, NumSelectedTrafoIDs), "TrafoID", SELECTEDVALUE(MeasurementsByFrequency[Serial Number]), "ColorID", LOOKUPVALUE(TblCSSColor[Hex rgb],TblCSSColor[ColorID],[Value]) ) RETURN VAR Output= MAXX( VirtualTable, //VAR CurrentTrafoID = [TrafoID] //RETURN IF( NumSelectedTrafoIDs = 0, BLANK(), SWITCH( TRUE(), //[TrafoID]=CurrentSelection, CONTAINSSTRING(SelectedTrafoIDs, CurrentSelection), [ColorID], BLANK() ) ) ) Return Output anyone can help?
