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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.