Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.