search

Profitbase / PowerBI-visuals-FinancialReportingMatrix

Power BI Custom Visual for Financial Reporting
72 stars 23 forks source link

"Update all Columns Style" request #485

Open rax87 opened 1 year ago

rax87 commented 1 year ago

Currently, column formatting only works on specified columns. Can we apply style formatting to all? Particularly useful when a new column gets populated from the source automatically. If we take a balance sheet for example, and we spread each year into columns, once the current year elapses, a new year column will be added from the source. It would be great if this column can have the formatting applied based on other formatted columns.

AndersAano commented 1 year ago

Hi @rax87,

You should have two options when it comes to Conditional Formatting: 1) Conditional Formatting 2) Column Conditional formatting

The first one should be measure specific, meaning the formatting you apply will be applied to every instance of that measure. If the measure shows for all years, then all will have the same formatting.

The second is column specific, and only applied to the column you choose. So even if your measure "Acutal" is populated for 3 different years, the formatting will only be applied in the year you selected.

Is that not the case for you?

Best regards Anders