How smart is the SMART NARRATIVE visual in Power BI?

Подписаться 224 тыс.

Просмотров 15 тыс.

50% 1

Let's explore how smart is the SMART NARRATIVE visual in Power BI and see how good the insights are that it automatically generates. Is it ready to be used in your reports and how can we use it in a smart way?
Enjoy and.... subscribe, like and comment :)
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00 Intro
0:23 Smart narrative intro
1:19 Enabling the smart narrative visual
1:52 Using the smart narrative visual
4:29 Customizing the text box
9:56 Few remarks on the smart narrative visual
11:38 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on RU-vid: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX

Наука

Опубликовано:

2 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 29

@bkundrat 2 года назад

Your videos are so very practical and very glad I found them. I appreciate all the effort you put into these and what you share. In this case for example, I was not aware of the features in the text box visual that would allow you to roll your own smart narrative. Brilliant!

@brettwilson3795 Год назад

2 years on and smart narratives hasn't progressed much. I recently tried to add one for a visual with a budgeted and actual value over a 12 month timeline and it kept referring to the budget value, so had to add in a text box version instead. Great presentation by the way.

@chuckt8246 3 года назад

Yes! this is the part I was missing. Just skip the visual and make your own text box. Thanks!

@HowtoPowerBI 3 года назад

haha yes .. that's also how I would use it 🤗

@MijalisMendiz 2 года назад

Hi Bas! Is there a way to remove the green line that appears under the value? As in your example you are changing the color to orange, the green line under it seems unnecessary. Thx!

@gnavarrolema 2 года назад

¡Gracias!

@HowtoPowerBI 2 года назад

Thanks Gustavo for supporting the channel!

@bastienplanson5055 3 года назад

Very nice thanks! Do you have any idea about how to get rid of the underlining? (would be great for printing)

@HowtoPowerBI 3 года назад

I don't think that is possible 🙁

@anjalisingh1588 Год назад

Hats off

@HowtoPowerBI Год назад

Thx!

@mshparber 3 года назад

Nice. What about conditionally color negative values as red, positive - green?

@HowtoPowerBI 3 года назад

I don't think that is possible yet. Workarounds I could think of (1) have a measure that conditionally show emojis up/down error (2) have two values next to each other. One shows when negative and the other when positive - give them different color.

@sonal008 9 месяцев назад

It is not giving me value for division to get percentage value later

@WyneeKariuki 3 года назад

Would it be possible to list multiple items from multiple column on a smart narrative visual or is there need to design DAX. Example to display COVID-19 cases reported across continents on a selected date: Source columns are([Reporting date], [Continent], [Total cases]) Required output should look like the following on the smart visual upon filter using Reporting date (Europe(300), Middle East(500), N.America(700),Africa(490),Asia(150)

@barttitulaerexcelbart9400 3 года назад

Custom Texboxes seems great! maybe the developers of Power BI should remove then the Card or Multi Row Card, since compared to these Texboxes they seem obsolete. Otherwise the list of visuals will be longer and longer. Of course take into account visuals that were made with older versions...

@HowtoPowerBI 3 года назад

get your point 🙂 , although they have some functionalities that you can't achieve with just customising the textboxes. I think that opens a whole new discussion on what visualisations should be there as a default option vs moved to the market place. Although you can always unpin / pin the visuals as you like it.

@totvabe1 3 года назад

I've been playing with it but I've been unable to show the multiple values selected in a slicer. If I want to see the content of the smart narrative updated when a select multiple values in a slicer at the same time, I can only see the name of one of them. Do you know how to do it? Thanks.

@HowtoPowerBI 3 года назад

I think the quick measure --> concatenated list does what you are looking for. Let me know 🙂

@totvabe1 3 года назад

@@HowtoPowerBI Great idea!

@sabasoleimangoli1950 Год назад

Is this possible to use SMART NARRATIVE in Power BI Report Server?

@zm2813 3 года назад

It's really weird but I don't see this smart narrative under my Preview Features. And I have a newer version Version: 2.84.981.0 64-bit (August 2020)

@HowtoPowerBI 3 года назад

you need to upgrade to the new september version (2.85.681.0 64-bit (September 2020)) 🙂

@anjalisingh1588 Год назад

Are smart narratives dynamic??

@anjalisingh1588 Год назад

hnji

@antoniolionetti8688 3 года назад

Download link not working

@HowtoPowerBI 3 года назад

thank you for spotting it! it is working again

@fewpoundcory 2 года назад

are u paul davids long lost brother?

@TimingIsEverything13 4 месяца назад

I need some help with using measures that contain filtering in the logic. For example, I have formatted my measure for % change you to the following, but its not picking it up. v1: This one is working. Text_HC%ChangeYoY_Global = VAR PercentChange = [_HC%ChangeYoY_Global] RETURN SWITCH( True (), PercentChange >= 0, "increased by " & CONCATENATE( ROUND( PercentChange * 100, 1), "%"), PercentChange < 0, "decreased by " & CONCATENATE( ROUND ( PercentChange * -100, 1), "%"), PercentChange = BLANK(), "", BLANK() ) v2: This one is not (and unfortunately the rest of my measures have filtering logic) - It is the same base measure for Global except with the filtering of the a DIM table for home country = USA Text_HC%ChangeYoY_USA = VAR PercentChange = [_HC%ChangeYoY_USA] RETURN SWITCH( True (), PercentChange >= 0, "increased by " & CONCATENATE( ROUND( PercentChange * 100, 1), "%"), PercentChange < 0, "decreased by " & CONCATENATE( ROUND ( PercentChange * -100, 1), "%"), PercentChange = BLANK(), "", BLANK() ) with _HC%ChangeYoY_USA = _HC%ChangeYoY_USA = DIVIDE( [_HC USA], [_HC USA PY] ) - 1 where _HC USA = VAR MinDate = MIN( Calendar_FY_To2025[Fiscal_BOP] ) VAR MaxDate = MAX( Calendar_FY_To2025[End of Month] ) VAR Headcount = CALCULATE( COUNTROWS( Actives_Mthly ), FILTER( VALUES( Actives_Mthly[File.Capture.Date] ), Actives_Mthly[File.Capture.Date] = MaxDate ), FILTER( 'Home Country DIM', 'Home Country DIM'[Global_Label] = "USA" ) ) RETURN Headcount Any guidance on what I am doing wrong?