topic Table Background - Conditional Formatting in Desktop

Table Background - Conditional Formatting

Anonymous — Thu, 12 Jan 2023 14:36:33 GMT

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!

Re: Table Background - Conditional Formatting

lbendlin — Sun, 15 Jan 2023 02:37:49 GMT

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

Re: Table Background - Conditional Formatting

Anonymous — Mon, 16 Jan 2023 07:29:34 GMT

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!

Re: Table Background - Conditional Formatting

BipinLala26 — Mon, 30 Oct 2023 00:29:12 GMT

@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!

Re: Table Background - Conditional Formatting

lbendlin — Mon, 30 Oct 2023 00:34:32 GMT

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41