Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
ddayanand
Frequent Visitor

Conditional formatting DAX

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.

 

 

ddayanand_0-1676024216400.png

Thanks,

1 ACCEPTED SOLUTION

@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

View solution in original post

4 REPLIES 4
ddayanand
Frequent Visitor

@Manoj_Nair  This was very helpful. Thanks a ton!

FreemanZ
Super User
Super User

hi @ddayanand 

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

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)

@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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.