Forum Discussion

spagad6263's avatar
spagad6263
Icon for Post Patron rankPost Patron
1 year ago
Solved

How to set table row text color by conditional formatting

Hi,

 

I would like to format the first row in table text as RED. I've set the number in RED throught Cell Element property using DAX. However, I don't to be able to find where I could set the ROW text (2024-09). Any suggestions? Thanks so much for the community.

 

 

Need Help

11 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    1 year ago

    Hi,

    I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

    In the sample, I tried to use visual calculation to set-up the color condition, and then make it as the Font Color condition for the value that is in the matrix visual.

     

    Using visual calculations in Power BI Desktop - Power BI | Microsoft Learn

     

     

    Please check the below picture and the attached pbix file.

     

     

     

     

  • spagad6263's avatar
    spagad6263
    Icon for Post Patron rankPost Patron
    1 year ago

    Thanks Kim for the quick response. What I would like to have is to also show the month in red, like below

     

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      1 year ago

      Hi,

      I am not sure if this could be done because it is not a measure but just a column from dimension table.

      However, please check the attached file, and I tried to workaround to achieve similar to what is expected.

      Thank you.

       

       

       

      • spagad6263's avatar
        spagad6263
        Icon for Post Patron rankPost Patron
        1 year ago

        Hi Kim, I can't find below field in the attached file. Can you please advise? Thanks

         

    • spagad6263's avatar
      spagad6263
      Icon for Post Patron rankPost Patron
      1 year ago

      Hi, can you post the DAX in TEXT? It's hard to read the screenshot. Thanks

      • spagad6263's avatar
        spagad6263
        Icon for Post Patron rankPost Patron
        1 year ago

        Please ignore my comments. I've found the DAX in the downloaded file. Thanks.

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi spagad6263,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you Ashish_Mathur, Jihwan_Kim and Ahmedx for the prompt response. 

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa

    • spagad6263's avatar
      spagad6263
      Icon for Post Patron rankPost Patron
      1 year ago

      Sorry for the late reply. I am travelling overseas and will follow the advice and see if they work. Much appreciated!