Forum Discussion

Ritaf's avatar
Ritaf
Icon for Responsive Resident rankResponsive Resident
4 years ago
Solved

Title for chart with multiple colors

Hi is this the way to color part of the title with different colors using dax and conditional formatting? 

For example, I need my title to be "Budget vs Actual".

Can I achieve it without using a text box?

  • Ritaf's avatar
    Ritaf
    4 years ago

    Hi, 
    Thank you, I needed it for the title, so just used textbox.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Ritaf ,

    Based on my research, It is unsupported to achieve your requirement with a table visual. As a workaround, you may try to use a matrix visual.

    Here is my sample data.
    Table:

     

    Then click the matrix visual>>Format your visual>>specific column.

    Then only open apply to headers.

     

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

    • Ritaf's avatar
      Ritaf
      Icon for Responsive Resident rankResponsive Resident

      Hi, 
      Thank you, I needed it for the title, so just used textbox.

  • mohammedadnant's avatar
    mohammedadnant
    Icon for Impactful Individual rankImpactful Individual

    Hi Ritaf 

     

    Why do we need this kind of requirement,

    it is not possible to do in 1 single measure

     

    If this solves your issue, please mark this answer as a solution and give thumbs up

     

    Thanks & Regards,

    Mohammed Adnan

    Learn Power BI: https://www.youtube.com/c/taik18

    • ducky's avatar
      ducky
      Icon for Advocate I rankAdvocate I

      I was looking for that as well and stuck upon your reply. The OP is asking for a solution not for why the requirement. This isn't us solving/challenging their business context or requirements. 

    • NOAHSWANSON's avatar
      NOAHSWANSON
      Frequent Visitor

      I think this ask makes sense in many visual examples from places like Storytelling with data.  I stumbled on this specifically looking to use the sub-title as a hack for a legend (the legend will not work for the formatting I want to describe as I want to use it to explain the conditional formatting in the visual.