cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zzakir
Helper I
Helper I

Smart Narrative: If DAX results in no value in PowerBI

Hello,

I am trying to create a smart narrative and I was able to get most of the variables on my narrative except for the one in red which is favorable or unfavorable depending on a dax.

 

Narrative:

Budget for the month of May totaled $5M compared to actual expense of $1M, resulting a favorable/unfavorable variance of $4M

 

Dax:

Budget_Sentiment =
If([Budget Variance] < 0,
"unfavorable",
"favorable"
)
 
Note that when I put this Dax on a card in the same page, it works! but in a smart narrative it ends up with the hidden symbol Any idea on what may be happening here?
5 REPLIES 5
Eyelyn9
Community Support
Community Support

Hi @zzakir ,

 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Hope to hear from you😀

 

Best Regards,
Eyelyn Qin

Eyelyn9
Community Support
Community Support

Hi @zzakir,

 

Sorry for that the information you have provided is not making the problem clear to me.

I have built a data sample like this:

Budget Variance = SUM('Table'[Budget])- SUM('Table'[Actual Expense])
Budget_Sentiment = If([Budget Variance] < 0,"unfavorable","favorable")

set a flag.PNG

Actually I'm confused about your descriptions:

"If DAX results in no value"

"in a smart narrative it ends up with the hidden symbol "

 

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@Eyelyn9 Hello Eyelyn,

Here is my measure:

zzakir_2-1624626690545.png

The measure works for me when I put it in a card or on a table but when I try to use it as a dynamic value it does not:

zzakir_3-1624626917599.png

 

I have circled the hide symbol I was refering to... I hope it was clear now.

Furthermore, when you hover over the symbol it says "Current data and filters produce no result for this value" which is clearly not true as you can see it does produce the result on a card visual.

I meant the "If" Dax/formula results in no value. I should've put "if" in quotes for clarity.

 

 

Eyelyn9
Community Support
Community Support

Hi @zzakir ,

 

Sorry, I'm still confused...

To my knowledge, the default value of measure shown in Card visual is the Aggregate value not the actual value:

Aggregate value.PNG

It is suggested share me with your pbix file after removing sensitive data and describe your expected output in detail to help us clarify your scenario.

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Eyelyn,

The issue is not resolved. I am unable to attach the file like you did. Have you worked with using "dynamic values" in a text box? I think part of the reason you are having issues understanding the problem is due to that. I can't remove sensitive data as its a huge file. Lets try one more time:

 

I have something similar to what you have in the .pbix you attached to this thread. The issue is that when I add the measure as dynamic "value" to the text box it shows no value (note the screenshot below). 

zzakir_0-1625005644672.png

If I use the same measure in a card, it shows favorable/unfavorable depending on the filters applied.

zzakir_1-1625005823216.png

 

Why would the measure work in a card or table visual but not work as a dynamic "value"?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors