Forum Discussion

HaiVN's avatar
HaiVN
Helper III
8 months ago
Solved

Turn on Format / Measure option

Hei,  How can I turn on this option in Power BI desktop  Thank you! 
  • Hans-Georg_Puls's avatar
    8 months ago

    Hi HaiVN ,

    there are at least two options to do that for a single measure:

    1. Choose "Dynamic" as Format from the Formatting Ribbon in Report-View
    2. Switch to Model-View, select a measure and choose "Dynamic" as Format from the Formatting section on Properties Pane
  • Anand24's avatar
    8 months ago

    Hi HaiVN,
    Click/Select the measure and select "Dynamic" in Measure Tools -> Formatting Section -> Format (see red blocks in below snapshot).

     

     
    Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

    Proud To Be a Super User !!!
    LinkedIn
  • cengizhanarslan's avatar
    8 months ago

    To see the "Format" dropdown menu shown in your screenshot, follow these steps:

    • Select the Measure: Click on the specific measure in the Data pane that you want to format.

    • Navigate to Measure Tools: Go to the Measure tools tab in the top ribbon.

    • Change Format to Dynamic: In the Formatting section, click the Format dropdown and select Dynamic at the very bottom.

    • Access the Format Script: Once "Dynamic" is selected, a new dropdown will appear to the left of the DAX formula bar. Switch this from Measure to Format to write your dynamic formatting logic.