cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Levajar Regular Visitor
Regular Visitor

Data is Off

When i use function to display UP/DOWN arrow with thresholds/conditional formatting - the relationship is getting lost & data is OFF. What could be the solution to resolve this ? 

 

Formula : 

Trend =
VAR Down =
UNICHAR ( 11167 )
VAR Up =
UNICHAR ( 11165 )
VAR Side =
UNICHAR ( 11166 )
RETURN
IF ( 'Table1'[% Metric1] < 0, Up, IF ( 'Table1'[% Metric2]> 0.1, Down, Side ) )
8 REPLIES 8
Levajar Regular Visitor
Regular Visitor

Re: Data is Off

Please let me know if someone has any idea why the data will be off (i.e.) relationships are not working while using functions. 

 

USERELATIONSHIP() not sure if that will resolve - i tried & it didn't.. 

 

So looking for some expert advise..

Community Support Team
Community Support Team

Re: Data is Off

Hi @Levajar ,

 

I think [% Metric1]and [% Metric2] should be measures here. Could you please share the formula of them? BTW, please share your sample data to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Levajar Regular Visitor
Regular Visitor

Re: Data is Off

@v-frfei-msft  Yes, those are measures

 

here you go with formula

% Metric 2 = DIVIDE(SUM(Table2[Numerator]),SUM(Table2[Denominator]),0) 
Numerator = Table2[Col1] - Table2[Col2]
 
Please review and advise. Unfortunately, it has sensitive data and hence, couldn't share the pwbx file here. 
vanessafvg Super Contributor
Super Contributor

Re: Data is Off

@Levajar  its going to be hard to resolve this without the data, can you create sum dummy date that has similar values?


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Levajar Regular Visitor
Regular Visitor

Re: Data is Off

Levajar Regular Visitor
Regular Visitor

Re: Data is Off

@vanessafvg  any changes for you to look at that one drive document. Please advise. 

 

vanessafvg Super Contributor
Super Contributor

Re: Data is Off

@Levajar  I will look at home tonight.


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Community Support Team
Community Support Team

Re: Data is Off

Hi @Levajar ,

 

I cannot access the file you shared. Could you please share it again ?

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 45 members 1,215 guests
Please welcome our newest community members: