topic Re: Conditional formatting DAX in DAX Commands and Tips

Conditional formatting DAX

ddayanand — Fri, 10 Feb 2023 10:19:34 GMT

Hi,

I have a forecast waterfall report below. Can anyone please help me with a measure which I can use to condition format the red lines. Red lines are actual demand and the not coloured values are the forecast. So I need this formatting to work in a step to differenciate the actual demand and forecast.

Thanks,

Re: Conditional formatting DAX

FreemanZ — Fri, 10 Feb 2023 11:03:02 GMT

hi ddayanand

could you also provide a simplified dataset for the needed conditionally formatted matrix?

Re: Conditional formatting DAX

ddayanand — Fri, 10 Feb 2023 11:25:45 GMT

I have two tables

1. item code, global planner code, region, snapshot date and a calculated measure giving the concensus forecast

2. Calendar table (diplayed in the column)

Re: Conditional formatting DAX

Manoj_Nair — Fri, 10 Feb 2023 18:51:30 GMT

ddayanand - Please check this PBIX file with some dummy data on your giving datasets. Let me know if this solution works for you. I've created conditional formatting by background color. you can use font color. But if you are looking for an underline, maybe check out the calculation group option. I'd did post a while ago on LinkedIn. I am sending you the link for your reference.

2023_02_10_Conditional%20formatting

Calculation Group Link

Thanks

Re: Conditional formatting DAX

ddayanand — Mon, 13 Feb 2023 11:43:57 GMT

Manoj_Nair This was very helpful. Thanks a ton!