Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Table Background - Conditional Formatting

Hi, 

 

I'm attempting to add a light mode/dark mode option in my report and I've succeeded to do the workaround in all the visuals so far but the table. 

The screenshots below are showing what the end outcome I'm looking for when I toggle the Dark Mode/Light Mode button with the DAX formula below (I use it for all the other visuals in the Conditional Formatting function and I have a table in the background with the HEX colours for each option): 

Colour Background =
VAR _selected = SELECTEDVALUE(Colours[Background])
RETURN
IF (ISBLANK(_selected), "Dark", _selected)
 
I know I can do conditional formatting in a table for each field, but it takes away the alternate row effect and if there is no other choice, I'll probably go that way. But for larger tables, it's a total headache.
 
The question is: Is there a DAX Code or workaround to add conditional formatting to an entire table for:

Text Color
Background Color
Alternate Text Color
Alternate Background Color
 
The information shown below is from Power BI finance sample by the way: 

 

Thank you very much for all your support!

 

Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    use two different table visuals, each with their theme, and then use bookmarks to switch their visibility.

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    use two different table visuals, each with their theme, and then use bookmarks to switch their visibility.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      hi lbendlin that's definetly a solution!

       

      Although I do have another bookmark for filters, so I'll exponentially double my number of bookmarks to work around that table.

       

      Please let me know if there are other ways. (I sort of already gave up and chosen the column conditional formatting. One thing that I hate is that the column header colour doesn't have conditional formatting.)

       

      Thanks for the tip!

  • BipinLala26's avatar
    BipinLala26
    Frequent Visitor
    2 years ago

    Anonymous  - I also spent few hours on implementing the light/ dark mode option in my report for all the visuals and background, but in the end got stuck for table/ matrix.

    Its really sad that there is no option/ shortcut to add such formatting on text and cell background in a better & faster way than using conditional formatting. I have huge tables on some pages and can't really add conditional formatting to each page. Will have to drop the entire idea of theme changing option.

     

    I hope there is a solution for this soon!