Power BI: Dynamic Format String for Measures

Published: 04 May 2023
on channel: Dhruvin Shah
5,828
69

Recently Microsoft launched new Power BI feature - "Dynamic Format String for Measures". With dynamic format strings for measures, you can determine how measures appear in visuals by conditionally applying a format string with a separate DAX expression.

Dynamic format strings overcome an inherent disadvantage of using the FORMAT function. That is, with FORMAT even numeric data types are returned as a string, which may not work with visuals that require numeric values, like charts. When using dynamic format strings, the measure keeps its data type and isn't forced to change to a string data type. This applies different format strings to the measure depending on the context.

Reference Link: https://learn.microsoft.com/en-us/pow...

*******
Follow Dhruvin on Social Media:
Follow my other channel for short content: ‪@DigitalDhruvin‬

Follow me on Instagram:
  / powerplatformguy  

Looking for a Consultancy? Connect Here!
https://powerplatformtrainings.com/co...

Follow me on all social Media Handles:
https://linktr.ee/dhruvin.shah

#PowerBI #PowerPlatform #PowerAddicts #DhruvinShah #DigitalDhruvin #DAX


Watch video Power BI: Dynamic Format String for Measures online, duration hours minute second in high quality that is uploaded to the channel Dhruvin Shah 04 May 2023. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 5,828 times and liked it 69 visitors.