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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
NDD
Frequent Visitor

Unable to see the formulae for measures

Hello,

I downloaded the Retail Analysis Sample PBIX file from learn.microsoft.com. I cannot view the formulae for any of the measures. Is there a way to see them? If not , could someone please tell me what is the formula for the measure "Status" as shown below:

NDD_0-1666560116349.png

 How does it autmomatically become a traffic light indicator when added to a table visual without any conditional formatting?

NDD_1-1666560236911.png

 Thanks in advance!

1 ACCEPTED SOLUTION
AbbasG
Memorable Member
Memorable Member

@NDD Hi, not sure if you can view the measure in the pbix file. NDD.pbix


However, it is a measure and will not require any conditional formatting.

You can create a similar measure,  (it is a simple IF condition with Icon to make the table visually more appealing).

Attached is the PBIX file with sample data, hope it helps 🙂


AbbasG_0-1666583653106.png

 



 






 

View solution in original post

1 REPLY 1
AbbasG
Memorable Member
Memorable Member

@NDD Hi, not sure if you can view the measure in the pbix file. NDD.pbix


However, it is a measure and will not require any conditional formatting.

You can create a similar measure,  (it is a simple IF condition with Icon to make the table visually more appealing).

Attached is the PBIX file with sample data, hope it helps 🙂


AbbasG_0-1666583653106.png

 



 






 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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