cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MarioVW
Frequent Visitor

Dynamic values in text box

Recently (I believe May 2021 version) I noticed that now any text box visual in Power BI Desktop gives me the option to add dynamic values (not a Smart Narrative visual, but a simple text box). However, any time I try to use it I get the message: "Adding dynamic values isn't supported in this application." 

 

Can anyone provide guidance on why I might not able to use this new feature, and what would I need to change/adjust in order to be able to use it?

 

MarioVW_0-1623224859084.png

1 ACCEPTED SOLUTION
MarioVW
Frequent Visitor

I just found the cause of the issue, I'm posting it for anyone else reading this thread.

 

Adding dynamic values on Smart Narratives visuals (and in text boxes) uses the Q&A feature under the hood. So I tried to add a Q&A visual and I got an error message saying that Q&A was not supported for this report.

MarioVW_0-1625869098535.jpeg

 

The problem was that the language was configured as Spanish, even though I had the Spanish language support for Q&A preview feature turned off (I might have turned it on sometime in the past but then turned it off again, but apparently the model language was stuck as Spanish). Once I changed the model language back to English everything started working smoothly.

MarioVW_1-1625869125206.jpeg

View solution in original post

9 REPLIES 9
MarioVW
Frequent Visitor

I just found the cause of the issue, I'm posting it for anyone else reading this thread.

 

Adding dynamic values on Smart Narratives visuals (and in text boxes) uses the Q&A feature under the hood. So I tried to add a Q&A visual and I got an error message saying that Q&A was not supported for this report.

MarioVW_0-1625869098535.jpeg

 

The problem was that the language was configured as Spanish, even though I had the Spanish language support for Q&A preview feature turned off (I might have turned it on sometime in the past but then turned it off again, but apparently the model language was stuck as Spanish). Once I changed the model language back to English everything started working smoothly.

MarioVW_1-1625869125206.jpeg

RMB
Resolver II
Resolver II

Do you have RLS or OLS setup on that data set? I've found that I will get that error on projects with OLS setup. Not sure if that's by design or not.

MarioVW
Frequent Visitor

Yeah, I haven't seen the feature documented anywhere, but still I see it when using Power BI Desktop, but for some reason I'm unable to use it. I understand and have used the workaround suggested by @v-deddai1-msft but my question is regarding this (yet) undocumented new feature.

Hi @MarioVW ,

 

Based on my test, we can add measure to the text box in the latest version from microsoft store(It could be more latest than you can download from the download link):

 

Capture16.PNG

 

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

 

Best Regards,

Dedmon Dai

I'm on the latest Microsoft Store version (June 2021, version 2.94.921.0 64-bit) and I'm still seeing the same behavior as in my original post. In addition, I'm seeing the exact same behavior when using the Smart Narrative visual instead of a plain text box.

 

Is anyone else seeing the message "Adding dynamic values isn't supported in this application" when trying to add dynamic values using the Smart Narratives visual (or a simple tex box)?

I am too, looking at the language settings but there should be no reason why my language would be Spanish.

Interestingly my ability to turn on Q&A is greyed out @v-deddai1-msft @MarioVW 

v-deddai1-msft
Community Support
Community Support

Hi @MarioVW ,

 

I didn't find this new preview feature in https://powerbi.microsoft.com/en-us/blog/power-bi-may-2021-feature-summary/

 

As a workaround, you can use conditional formatting for title. For more details, please refer to https://community.powerbi.com/t5/Desktop/dynamic-text-box-using-filtered-date/m-p/1748248

 

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

 

Best Regards,

Dedmon Dai

amitchandak
Super User
Super User

@MarioVW , I am able to use the same in the May 2021, release.  I do not see any preview option for that.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!