Bas, fantastic video as always! Note to my fellow watchers: remember to first go to the report Options and enable this preview feature. As for a use case, how about when you have a beautiful switch between Amounts and Quantity? This is what I'm using it for. Amounts must be in thousands, and Quantity in, well, regular formatting. And for thousands, I used "#,##0,.k", to see the 'k' at the end. Update: fudge, the formatting is a mess when we use it in a visual (the thousands one) and apply data labels! It's all over the place!

I found it incredibly useful, as always! Thanks for consistently updating all of us with the latest and most innovative content! I truly appreciate it!

Amazing video! Your workaround for measure driven labels solved my problem!

Thank you mate, I've struggled with formatting for half a day, you saved my @$$ and won a new follower! ;)

Thank you very much for these video. Was exactly what I was searching for. You are great!!

This is really out of the Box Thanks Bas for great video.

Hi Bas, great tutorial (like always). I have a use case to have different formatting for every row from where I work: we have a sales table visual which shows a number of rows of sales actuals (in EUR) with right below it (in the same table) the number of units sold (of course in absolute values). It's not my preferred visual to do this because I find it confusing but management is used to this table so there you go 🙂

Hola Bas, Eres un crack. Mil gracias por compartir tu sabiduría. Abrazo fuerte

Hi Bas, great channel. Great videos. As a suggestion : I would love to see your version of reconciliation. In quantity and financial value maybe even with currencies. Accounts Receivables also very interesting. Thanks for the inspiration.

Thanks, especially for sharing the dimCurrency Table :)

Thank you. Realy good case.

Right on top! Great stuff

Thank you! Regarding dynamic formatting - will try it in matrices, I often use dynamic columns with some additional calculations following a set of periods (e.g. % variance of last period vs the previous)

@HowtoPowerBI

Жыл бұрын

not sure if i get the use case .. could explain more?

@digitsletters972

Жыл бұрын

I have a matrix with values containing sales by period (need number formatting), rows containing customers, columns containing not only periods but some additional calculations which demand different formatting: variance vs previous period(%), absolute variance (+-), weight of sales by customer in total sales (%), etc. I solved it by using a combination of SWITCH/SELECTEDVALUE/FORMAT() directly in a measure, but it has some inconveniences for users (while exporting to excel the columns with formatting are stored as text) and for me (additionally complicates my multi-row measure🙂). Hope I will be able to put that SELECTEDVALUE/FORMAT part into the dynamic format

Really Amazing...Thanks for this..

if its BAS then something out of the box, great thanks for sharing

Amazing video as usual

Thank you, Bas! You make my work shine!

@HowtoPowerBI

Жыл бұрын

Glad to hear this thx for the support!

As always, excellent Bas, thank you!

@HowtoPowerBI

Жыл бұрын

thank you very much for watching again !! :D

Hi Bas, super helpful and very well explained video. May you please add a video, with option allowing only currency symbol to be in bold and the figures as normal. Thank you

Thanks for this - we had a user requirement to show a measure value in K or M based on the the length or value itself and I just made a way to do this automatically with dynamic formatting - wouldn't have known about it if not for this video.

@paulgallagher2987

Жыл бұрын

I was thinking about this too. Did you do something along the lines of "IF [Sales] > 800,000 then M formatting else K formatting"

@LeighRadmore

Жыл бұрын

@@paulgallagher2987 yea basically, I used switch as there were multiple 'buckets'

@sholder9933

Жыл бұрын

Marco Russo just published a video on how to do this.

Hey Bas! You are a life saver man. One question, will this work for KPI Card displaying either decimal, percentage, or whole number for value and target? Thanks and keep it up!

when I was noticed with april update earlier this month, I knew Bas is going to give this lecture. Thanks bro, your version is the best

@HowtoPowerBI

Жыл бұрын

thank! lol -> what's gonna be my next vid?! ;)

Awesome video excited to try it out. Do you know if this will work for a visual that uses a field parameters those different values. At the moment i end up when some of the measures returns small amounts it wout show 0,0k.

Thanks for the content. Is there a way to add color to dynamic formatting? For example, I am in a table column and I want to use a UNICHAR arrow and make the up arrow (9650) green and the down arrow (9660) red, all within the dynamic formatting.

Great video as always Bas! Thanks a lot. And just when I'm about to need to do multi currency reporting. Please could you share the DAX for your MaxMin Measure. I don't understand how it outputs 2 different values. Is it a TRUE/FALSE output? eg MinMax = IF(OR( [Sales] = Maxvalue, [Sales] = MinValue), 1,0)

Hi Bas, Great content as usual! I have a use case, where I present a line chart and I'm switching between different measure (sales, units, baskets, etc.). The dynamic option for my calculations works fine, but the Y axis labels is not always following. Is there a way to make sure the Y axis also displayed the good units ? Thank you!

Great Stuff Bas! My first thought was to use a Len() function of some sort to determine the value length and then dynamically adjust the value display across a single table without the slider needed. You could put all the same currency logic also. Helpful if you have values in millions and thousands in the same column. Cheers!

@HowtoPowerBI

Жыл бұрын

thanks a lot :) yea, definitely also possible, just depends on whether you want that slicer. And also if you have many options (for example many currencies) probably the table is a bit easier.

Hi Bas, great video as always. can you show me what the minmax measure looks like please!?

Million thanks!

@HowtoPowerBI

Жыл бұрын

thank you for watching! :)

thanks!!

Thanks a lot super simple and understandable explanation , I did watch few videos but none comes across the way you explain and make it simple to understand. I had a request can you make a video to explain how we do all the advance filtering in a filter pane , doing those same things in slicer ?

@HowtoPowerBI

Жыл бұрын

thanks a lot! :) .. depends a bit what type of filter you are looking for .. not all of them are possible with a slicer in a similar way

Very helpful as always you do. Thank you Bas. Is it possible to display different currency values with Thousands, Millions, Billions.

Awesome thank you

@HowtoPowerBI

Жыл бұрын

thx!!! :D

Curious if you can use they for dates formats as well. Been struggling to figure it out on my own.

Hello Bas, awesome video as always... one doubt, do you know how I could format a specific column of a matrix so only the values of that column are with a bold font?

I found it increadibly useful.

@HowtoPowerBI

Жыл бұрын

Awesome!

Hi Bas, in my case the values has to be in $ and % . Is that possible?

Thanks for the video. I do have a request where the format string would be based on the count of digits in a number would be a specific format (IE. If the value is less than 1M show $#0.0K, if the value is less than 1K show $#0, etc.)

In the April version of the P-BI, I don't find the option to "Add more analysis to your look". On the MS blog I didn't find any technical note that talks about it. Do you know if it's available elsewhere or if it's a bug in this version?

Great Bass!

@HowtoPowerBI

Жыл бұрын

Thanks 😊

Awesome! Thank You so much! A request: Could you please share lights on % YOY, % MOM, %WOW, WTD using new window ,offset functions. Thank you again.

@HowtoPowerBI

Жыл бұрын

thanks! here you go :) kzread.info/dash/bejne/l52Wl7puqLXSqps.html

@nishantkumar9570

Жыл бұрын

@@HowtoPowerBI I rarely miss any of your videos, I already watched it and it helped me a lot in understanding those new function and it's implementation. Still I'm little bit confused on Month over month change and Week over week change.

Brilliant!

@HowtoPowerBI

6 ай бұрын

Thx Roy!

Thanks Bas 😍

@HowtoPowerBI

Жыл бұрын

thx for watching :D

this is amazing!!! is that currency table available somewhere? Thks

@HowtoPowerBI

Жыл бұрын

There is a download link in the description

Hi Bas, One question, Is it recommended to use these preview feature for our production report ? if yess, could there be potential damage to report in case Power BI removes that feature ?

Can I sort the dynamic format asc or desc? What's best way to do this? thanks

Great explanation.. But how to up or down arrow in data label

Great video as always, thanks. I'm working on a similar report that has several currency formats. Can share with us the URL where you got the different currency formats, please? Much appreciated

@HowtoPowerBI

Жыл бұрын

thank you! I've put the excel file in the download for this video :)

@nishanth4323

Жыл бұрын

@@HowtoPowerBI 👍👏

Hi Bas. As always, great videos! I have a requirement where the report should show a)the total sales for each country, and b)the total sales for the region. A region is a group of countries. Each region has its own reporting currency defined, e.g. Europe = EUR, Americas = USD, etc. Finally, the Group total is the sum of all regions, displayed in one Group-currency. Your video explains a way to show each country’s currency code - do you also have a solution for how to show Region subtotals and Group totals?

@HowtoPowerBI

Жыл бұрын

you would need to adapt/extend the logic of the dax expression for the formatting string .. check if not isfiltered(dimRegion[region]) then the group currency otherwise check which reigon is selected -> selectedvalue([dimRegion[region])="EMEA" then euro

What if on last tread graph , I want to show negative number in red font and in brackets.. only negative numbers.. how to achieve that

I didn't know that you had to go into options and enable preview features in order to do this, and was wondering/googling for ages as to why I didn't have dynamic as a formatting option despite being on the most recent verion of PowerBI. Please can you specify this for beginners like me 😭

Bas, what if I don't want to format into strings but keep the values. However, I need to show either a decimal, currency, int, or percent based on user selection on a matrix. Is that possible with dynamic?

@HowtoPowerBI

Жыл бұрын

sure :) its like the unit example -> build a table that contains decimal, currency, int, pct in a column. use that for a slicer. Use dynamic format to see which one is selected and return the values with the format you like.

@theshakoone

Жыл бұрын

@@HowtoPowerBI thank you. I currently have the data type in the dim and am trying to change the data type on the line chart that is displayed. I will keep trying workarounds.

Hi, please let me know how to add the slider values in the table like in this video

can someone explain about the four quotation marks functioned?

Can we do calculations in the dynamic format string, like lookup exchange rate and then format?

@HowtoPowerBI

Жыл бұрын

Yes

Using the formatting option to show complex labels instead of having to use calculation groups (which could be often problematic depending on where else you used the same measure or the axis) is the bigger update for me.

@HowtoPowerBI

Жыл бұрын

Its still a bit of cluncky work around. :) an fx button to set label values would b nice

how about using Dynamic formating Strings (i didn't check if this was already suggested sorry) to "suppress" small number count. e.g. if the resulting value is greater then zero but less then 15 display a "suppressed" else value .... great content btw bud!! keep it up

@HowtoPowerBI

Жыл бұрын

thanks for watching! :) i was thinking about scenarios like that as well, but I probably would then just filter those small values out instead of showing a different format .. or ?

@joeyjojojrshabadoo

Жыл бұрын

@@HowtoPowerBI you could do that but you would be losing information in say, data tables when displayed, its suppressed data not null or lack of data, no? thoughts?

Nice 👍

@HowtoPowerBI

Жыл бұрын

thank you!

Hello Bas, can u give me a TIP in how you build the MAXMIN measure? I suppose u used variables like this: Var MaxValue = MAX('YourTableName'[YourValueColumnName]) Var MinValue = MIN('YourTableName'[YourValueColumnName]) Return IF( "Measure" = MAXVALUE, MAXVLUE, IF( "Measure" = MINVALUE, MINVALUE, BLANK())) Can u please correct me if im wrong, thanks in advance.

del lujo....

@HowtoPowerBI

Жыл бұрын

gracias !

😆 "Filipino currency symbol" - Lol. Philippine Peso. Very useful, Bas.

What do you do when you have values with Km , L and mpg units in the same column. Sample....

Need help! Matrix visuals are very very slow. I've put the dynamic format for 10 measures.

how to work on between numbers and %?

as a powerbi developer do we need to learn Power apps & power Automate ? how Power apps & power Automate will benefit for PBI developer.

Is there a way I can format percentages without %? For example, if the result is 51.3%, I want to show only 51.3, not 0.513.

Awesome! Thank you Bas! 🙌 Btw, do you mind sharing the the [MaxMin] dax? 😅

Did PowerBI remove this option? I have the latest version and don't see Dynamic as an option in the format dropdown

@HowtoPowerBI

8 ай бұрын

go to options, preview features, turn on dynamic format strings for measures

@Barrett-WB

8 ай бұрын

@@HowtoPowerBI Thanks!

😍

but how do you do this if you use SSAS?

👍👍❤️❤️

It's a bad practice to do a cross filter=both just so the slicers get filtered. Just apply an 'is not empty' filter on a measure to the slicer visual instead. Microsoft says this in their bidirectional relationships guidance page and it's super easy and quick to do.

@RichardOliver

Жыл бұрын

I use one I saw Alberto Ferrari do so, in all my models, there is a measure called 'The Alberto' that I use for this purpose.

@HowtoPowerBI

Жыл бұрын

yea that would be better :) thx for pointing it out

Hi. Thanks for this! How to show it as 100M? e.g. 900,000,000 will give me 9 instead of 0.9B or 900M.

@HowtoPowerBI

10 ай бұрын

kzread.info/dash/bejne/eIqe1rmopaebdto.html

❤️

@nishanth4323

Жыл бұрын

Bas

Colombia 💪

@HowtoPowerBI

Жыл бұрын

Netherlands 💪🙃

Kindly provide the video of Google Data Studio.

@HowtoPowerBI

Жыл бұрын

maybe one day

норм но плохо что нет на русском языке))) все красиво но ничего не понятно))))