Smart Narratives and Conditional Formatting in Power BI? Yes please!

Using Smart Narratives and you'd like to add some conditional formatting in Power BI? Patrick shows you some tricks to take Smart Narratives to the next level!
Download Sample: guyinacu.be/sm...
📢 Become a member: guyinacu.be/me...
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/co...
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com...
#PowerBI #SmartNarratives #GuyInACube

[@joeseroski1095]

I didn't even know you could do that with a regular text box. Awesome!

[@psz34]

Cool! Love the manually set up smart narratives, this conditional formatting adds the very desired by managekent touch to it

[@szklydm]

I love the smart text box, I argue it's one of the most powerful updates of the past months. I remember when I first saw it, I was actually trying to revert to the old one, not knowing what to do with it, I just had no clue it was smarter than me.

[@hi55us2]

That is so amazing, nice little hack and I like how flexible it is with any percentage you specify!

[@Дархан-г4ъ]

Wow, definitely I’m gonna use the smart narrative, thanks Patrick

[@vijayarjunwadkar]

Great tip! Thank you Patrick!

[@jonathankemp6803]

Thanks man, yes starting to use it, it's awesome.

[@VicMarshall-df1ff]

This is exactly what I've been looking for!! I have one issue, the 'how would you calculate this' isn't finding my measure as a suggestion 🤦‍♀Any Idea why?

[@dcpowered]

Another great video, Patrick! Cortana was the guest in this one! 😂👍 Could you please make a video on how to merge two tables using a condition? For example, the date in one of the table column should be less than today.

[@shiramano]

Mind blown. Thank you!

[@mateoc15]

My favorite "conditional formatting" is for +/- % change. Just change the format in the model view to a custom format like so: +0.0%;-0.0%;0.0% This shows a + in front of positive changes. 🤘

[@PLara-tf4eg]

Can you add color too? I want to show the change with red/green FONT

[@robertalavezzari6970]

you are really something else!!!

[@dpi3.14]

Patrick, thanks for the video! It's great as always. I have a question about using text measures in text boxes. For example this up arrow. It simply doesn't work in my case for some reason. ANY text measure is ignored. Any ideas who might be the issue? Google didn't help so far.. Thanks!

[@PLara-tf4eg]

Thank you thanks what i needed..i wonder if you can add color to the percentage ???

[@IRDSB]

I've found for easy Smart Narrative creation you either need to use DAX or create single row tables that update in Power Query and whereafter you can easily pull the values out without the nightmarish question wrangling.

[@rahularora2155]

Hi Patrick, thanks a ton to both of you guys..your videos helped me a lot to clear Da100 in first attempt.... Still one thought to be clarified..anyway is it possible to have multiple column based relation between tables..

[@HariharasudanP]

One active and another passive is possible. Else go with composite or surrogate key

[@imxltf]

Hi Patrick, such a nice tutorial! Anw, I had a problem when downloading your sample file, it said "Account is cancelled and can not accept new subscribers". Could you fix that so I can download the file sample, please? Thanks mate!

[@cherietidwell7821]

AWESOME!!!!😊

[@arameshkumar5072]

❤️ from India 🙏 Namaste Patrick Great effort 👌 Smart narrative visuals 💞

[@nickdoy7019]

Great video Patrick. We use smart narrative for quick text context usually things like "x had decreased/increased for the last x days" where the line chart on the page is there to show trends and that level of detail isn't immediately obvious. I was thinking, could you not have both arrows in a single switch statement with a defined hex colour for each though?

[@adnanmustafa73]

I followed these steps. However, when the Up Arrow is active, I can still see the placeholder for the Down Arrow and vice versa. How to show only one arrow?

[@SaniyaMapari]

I am facing the same issue..did you get any solution??

[@giangutierrez5109]

Hello! Thanks for this. But I would like to know if there's a way to format numbers like in your sample? I would like to use #,##0.0,,M format, cause the amount is too long to look at.

[@KiranKumar-hk5ji]

Hi Patrick in place of up arrow . Can we use unichar ??

[@lopypop]

nice! is there any plan to allow conditional formatting (colors) of values in text visuals in the future?

[@wmfexcel]

Wondering trick on the green and red coloring! I do mean it. :)

[@pbihari0214]

This is a great idea, thank you, Smart Narrative is not available in Power bi Report Server, is there anyway we can get it please

[@tomaskavicky]

with chocolate and cream! great thanks

[@hi_vishy]

Amazing stuff

[@karikoga320]

Hi Patrick. Thank you for this video, quite informative. I tried downloading the pbix file and I am getting the following error message "Account is cancelled and cannot accept new subscribers." Kindly assist

[@bijilashobanabalakrishnan7718]

Awesome 👏

[@Datanox]

Does synonym ambiguity affect smart narratives results just like QnA feature? Thanks.

[@koutlaw30]

Brillant

[@NagaNathanmp]

Yes definitely, smart narrative is being used like a fact check in data analytics dashboard which I have built

[@personalsigh]

Does anyone know if you can get a powerbi account as an individual user? I'm trying to understand if you can but every time I try it asks me to use a "work email"

[@osmanbaba1485]

Sign upto Azure and create a email address from there and then use that to sign up for PBI.

[@personalsigh]

@@osmanbaba1485 I'll give that a try. Cheers! 👍

[@rocioraquelriarta.9973]

Nice Patric you're so Smart like me

[@motheolophaleng800]

Im getting a blank, do you perhaps know why?

[@Baldur1005]

No gonna lie, smart narratives has amazing potential but the experience building them is far from optimal. For example you cannot format variable by left-clicking on it, you need to drag your cursor and mark it as you would do copy and paste. Great video though!

[@Garrin1977]

I’m no expert but I don’t understand why you can’t change the text in smart narrative. You said you can only append to it. So confused. Surely you can write whatever you want in there