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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Narukkp
Helper V
Helper V

Color condition format in Matrix visualization

Hi Team,

Anyone having the idea how to achieve the below scenario .

 

Currently I am creating the 3 measures for giving color(Green) condition based on Measure(Actual vs Plan) value. It is working as expected at date level but our client requirement is when ever month level if is equal then we have to show the Green color. Please  find below highlighted area Feb month level both actual and plan

both are same.

Actual = CALCULATE(SELECTEDVALUE('Sheet1'[Value]),'Sheet1'[Status]="Actual")

Plan = CALCULATE(SELECTEDVALUE('Sheet1'[Value]),'Sheet1'[Status]="Plan")

Actual Vs Plan = IF([Actual] =""|| [Plan]="",2,IF([Actual]=[Plan],1,0))

 

ProjectStatus.PNG

 

ColorCondtion.PNG

4 REPLIES 4
Cmcmahan
Resident Rockstar
Resident Rockstar

So you're saying that the entire month of Feb should be highlighted yellow because every project's Plan is the same as it's actual within the month?  Or just the bottom two cells? How is all this data stored in tables?

 

If you could anonymize your data and share the .pbix, it would greatly help us determine the best way to accomplish your goal.  Even just relevant dummy data in the same model as yours would be very helpful in getting towards a result.

 

 

Hi,

@Cmcmahan please help on this if you have any idea..

Hi Cmcmahan, Yes you are correct with in same if it is equal then we need to show Green color. Do u have any idea how to attach the pbix file and excle file here. For time being find below screen shot of excel data. Using below data i have unpivot the data and prepared the eariler screen shot reprot. 

 

ProjectDetails.PNG

Narukkp
Helper V
Helper V

Hi everyone ,

if Anyone having the idea about this scenario please share your thoughts. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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