Dynamic Format Strings 💠 Basic to Advanced: 5 Techniques

Here's a guide on how to show context with Dynamic Format Strings

Links:
=================================
=================================

Check out my other videos:
=================================
=================================

Thanks for taking the time to watch this video.

#powerbi #dynamicformatstring #microsoft

[zis]

The Y-axis problem from minute 10:55 - Bas from "How to Power BI" channel has a workaround for that - you create a dummy measure with irrelevant value (such as 0), put it in front of your measure and hide all of it's lines labels and markers. If you want to delete it from the tooltip too, you can create a custom tooltip.
Other than that, this is a good video, you are a competent instructor and you have a great production value, video editing, sound etc.
Good luck.

[ErknDrn]

Hi, Thanks for the video, it was very helpful. I have a question. In power bi, how to use dynamic format in horizontal bar chart

[moxie]

Hi Injae, great tutorial. Is it possible to upload the pbix? I'm using Power Toys OCR, with the measures being so long, but its not vey accurate. Thanks

[ronvanderpoel]

Hi, great stuff. How did you add that blue arrow up to the chart? Windows key and then ??

[oreoresi]

On the grind I see 💪 Keep up the banger work! (also when will you be on again)

[Gerschk]

is there a reason you used sameperiodlastyear vs dateadd for the LY selected axis? Min 17:25

[sohailansari]

Nice video can I find the pbix file, thanks

[Gandunomics]

Please provide the dataset and file so i can practice on it thanks

[christianenriquemendozarod]

El formato dinámico no me sale en matrices, es solo aplicado a tablas y otros visuales?

[anetakn]

Maybe a stupid question.
Can you explain this " " " " & and & " " " " part of the code? Line 10 and 12 in the Level 4 code.
I don't get it.

[jim_]

var __value = [Total Profit]

var __abs_value = ABS(__value)

var __format =
SWITCH(
TRUE(),
__abs_value >= FORMAT(__abs_value, "###, , .0M"),
__abs_value >= 1000, FORMAT(__abs_value, "###, .0K"),
__abs_value >= 0, FORMAT(__abs_value, "##0")
)

RETURN
"""" & __format & """"

Above is the DAX I used to dynamically format the Total Profit measure.

I would like to display Total Profit and Total Sales measures for Products in a Clustered column chart.

A minus sign should preceed the negative values of Total Profit, thereby indicating losses.

The Total Profit displays negative values with a minus symbol when they are visualized in a Line chart, but not when displayed in the clustered bar chart.

Can you explain how to display the Total Profit measure that is dynamically formattef in a clustered column chart with minus sign for negative values?