From Thousands to Billions: The Power of Dynamic Formatting in Power BI - April 2023 Power BI Update

#powerbi #video about the dynamic formatting feature that is most recently introduced in the #powerbi April 2023 update.

One of the key benefits of dynamic formatting is its ability to enhance the readability and visual appeal of data presentations. For instance, by switching to a billion value format, data that would otherwise be displayed as large numbers can be made more easily understandable to viewers. The video provides the solution on how to switch between value formats, such as thousands, millions, and billions, to suit the specific data being analyzed.

Additionally, it provides tips and tricks for leveraging dynamic formatting and a deeper understanding of how to use dynamic formatting to enhance data visualizations.

Enjoy and share, and leave your valuable and constructive feedback.  

#powerbi #businessintelligence #bi #perytus #decipheryourdata #powerbipro #powerbideveloper #dax #fieldparameters #calculationgroups #learnpowerbi #howtopowerbi #powerbitraining #powerbiforbeginners #dataanalysis #microsoftpowerbi #microsoftpowerbidataanalysis #visualinteraction #visualizaton #dynamicformat #powerbiupdate #powerbiapril2023update

[PowerBIHowTo]

Just a note on this video I mentioned that if you need to refer to the measure in the format expression you have to rewrite the DAX expression of the measure or create a base measure. Luckily we don't need to do this, you can refer to the measure within the format string. So the updated format expression will look like this:

VAR __totalSales = [Sum Sales]
VAR __baseFormat = "$ #, 0"
VAR __baseDecimal = "00"
RETURN
SWITCH (
TRUE (),
__totalSales < 1000, __baseFormat & "." & __baseDecimal,
__totalSales < __baseFormat & ", ." & __baseDecimal & " K",
__totalSales < __baseFormat & ", , ." & __baseDecimal & " M",
__baseFormat & ", , , ." & __baseDecimal & " B"
)

Special thanks to @johnt75 who pointed this out on the Power BI Community forum. We all learn from each other. Thanks @johnt75!

[ronvanderpoel]

great explanation as usual, Parvinder

[isidreb]

Very well explained, in detail. Thanks for sharing

[raulparra]

Excelente video como siempre. Gracias por compartir

[seyiabayomi]

Thanks for sharing this content ❤. Using this approach, how can we apply these steps to negative sales amount? Thanks

[sohailansari]

Awesome video, where can I find the pbix file?.. Thanks

[sahilrao]

do i have to learn javascript for the above script in format section

i am comfortable in programming language but i think learning javascript would not be that beneficial

[seen]

Great explanation. How would I change the formatting expression so that it produces a rounded integer to the nearest thousand, e.g $612345678 is $612M

[rishabh]

I think you can use selectedmeasure() for calling the measure

[Wzxxx]

Thank You very much. It really helped me. Moreover I couldn't figure out how to format value to millions or thousands - two commas, I did not know about it. I am a bit supraised that it is possible to combine two "strings" and it is recognized by DAX as a final string without " " in the final format