Forum Discussion

TrevorC's avatar
TrevorC
Icon for Advocate I rankAdvocate I
11 months ago
Solved

Reference theme dataColors with DAX

As a developer I want to be able to reference data colour hex codes via Dax. I can reference Divergent and Sentent colors but nothing else.  The reason I want to do this is to help me create tem...
Need Help
Anonymous's avatar
Anonymous
Not applicable
11 months ago

Hi  TrevorC ,
At this time, Power BI does not provide direct access to all theme color hex codes (dataColors) within DAX. You may wish to submit this as a feature request or upvote an existing idea using the link provided.
Fabric Ideas - Microsoft Fabric Community

As a workaround, you can create a disconnected color table with category–color mappings and use a measure like below for conditional formatting:
Color Code =
LOOKUPVALUE(
ColorTable[ColorHex],
ColorTable[Category],
SELECTEDVALUE(Data[Category])
)

Then apply this measure in the Field value option under conditional formatting to get theme based colors.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 months ago

    Hi TrevorC ,

    I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 months ago

      Hi TrevorC ,

      I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you